AD 96-18-13
Registered aircraft · 1,110
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:96-18-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-18-13')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:96-18-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-18-13') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N635RJRoyal Air Freight Inc · Waterford, MIN63FXTrn Aviation LLC · Lewes, DEN63UCJamrock Leasing LLC · Schenectady, NYN63WJKaylan Paige Leasing LLC · Grand Junction, CON63YMSun Country Products LLC · Tampa, FLN640RBTalfin Leasing II LLC · Heflin, ALN649TTTownes Aircraft Sales LLC · Paris, TXN64HAJoe Air LLC · Sellersburg, INN64MJM J Electric LLC · Iron Mountain, MIN64NBRcc Management & Aviation LLC · Magnolia, TXN650ABBank Of Utah Trustee · Salt Lake City, UTN650ACTen X Express LLC · Fort Myers, FLN650AHNice Trip LLC · San Juan, PRN650CBSzucs Attila · Port Orange, FLN650CGC G Bretting Manufacturing Co Inc · Ashland, WIN650CZTeam Aero LLC · Shawnee, KSN650FCOrion Igv LLC · Opa-Locka, FLN650GCBank Of Utah Trustee · Salt Lake City, UTN650HGHamlin Aviation LLC · Ormond Beach, FLN650JAAircraft Guaranty Corp Trustee · Oklahoma City, OKN650JLEncore Jet Management LLC · San Antonio, TXN650JSEwi Tn LLC · Gallatin, TNN650KPJt95 Airways LLC · Concord, CAN650PFAircraft Holding Solutions LLC Trustee · Newark, DEN650PJSouthwest Aviation Inc · Marshall, MNN650PTBurkim LLC · Hartland, WIN650RARomeo Alpha LLC · Addison, TXN650RCRosado William · Moosic, PAN650RPRussell Air LLC · Madison, INN650RTGlobal Aero Aviation Inc · Houston, TXN650SFBas Part Sales LLC · Greeley, CON650TASale Reported · Greeley, COSale reported, pending cancellationN650TWKwafr LLC · Richland Hills, TXN650WAWings Aloft Incorporated · Portland, ORN651CCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN651EJComprehensive Energy Aviation LLC · Longwood, FLN651EMWv Jet Experience LLC · Charleston, WVN651MKMaxfly Aviation Inc · Fort Lauderdale, FLN651SFN444cw Partners LLC · Spring, TXN652CCSu-N16 LLC · Oak Creek, WIN653CCRegistered aircraftN653FJDwts LLC · Powder Springs, GAN654CPN654cj LLC · Williamsburg, VAN655MDMargarita Flights LLC · Longwood, FLN655PEDunbar Aviation LLC · West Kingston, RIN655TCTlc Aircraft Leasing LLC · Vero Beach, FLN657DJCastiron 5 LLC · Wilmington, DEN65MLBae Systems Technology Solutions & Services Inc · Mojave, CAN660PAFriendly Aviation LLC · Dallas, TXN663TWButler National Inc · New Century, KS
Back to AD 96-18-13