AD 84-10-01 R1
Registered aircraft · 20,481
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:84-10-01-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
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:84-10-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1') 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.
N888SPHelsing Roy · Little River, CAN888TTRegistered aircraftN888WCStephens Milton D · Birmingham, ALN8891XHamilton Soaring Club Inc · Hamilton, TXN8892TOzair LLC · Manhattan, KSN8892XBlinn Randy · Priest River, IDN8893TBend Aircraft Rentals LLC · Bend, ORN8894XRenfro Clinton G · Anchorage, AKN8895TTanner Ken M · Chandler, AZN8896TMayer John B · Benson, AZN8897TZweigle Zachary John · Redding, CAN8898QNorthrop Grumman Systems Corp · El Segundo, CAN8898XSargent Matthew M · Glenwood, IAN8899XJohnston Thomas D · Heyworth, ILN889BABarr Air Patrol LLC · Mesquite, TXN889ESDalissandro Michael Douglas · Hampton, NHN889JBeasley William D Sr Trustee · Big Lake, AKN889SLCunningham Richard Scott · Bedford, TXN889TVD & P Gammill Farms · Marked Tree, ARN88BLBrewer Jim L · Loco, OKN88CZThree Holer LLC · Clayton, GAN88DLLight Equipment Service LLC · Sunset, LAN88HQAviation Capital Management LLC · San Jose, CAN88JDRichardson H L · Reform, ALN88MALowry Michael L · Chesterton, INN88MLProstar Flight Services LLC · Bozeman, MTN88NESorjen Inc · Indian Trail, NCN88PBBraswell Jerrold W · Dillingham, AKN88PKGray Farms Inc · Albany, ORN88RBWarner David J · Englewood, OHN88RKJkg LLC · Idaho Falls, IDN88SQBank Of Utah Owner Trustee · Salt Lake City, UTN8900TSkyote LLC · Boise, IDN8901XHilde Justin · Statesboro, GAN8902TShort Steven A · Neillsville, WIN8903XGreene Bruce · Asheville, NCN8904XPlanes Of Fame Air Museum · Chino, CAN8906TTln Aviation LLC · Stanwood, WAN8907GInfinity Aviation · Pine Island, MNN8907QBurks Excavation Corp · Hailey, IDN8907XFrey Harlan Jerome · Carey, OHN8908TWinit Matthew C · Woodland, WAN8909TFinley Steven V · Fort Collins, CON8909XHubbert Stephen B · Owasso, OKN890MBVan Bortel Aircraft Inc · Arlington, TXN8910TSaa Enrique A · Lubbock, TXN8910XElardi Frank Paul · Upland, CAN8912XAman Douglas A · Fairfield, ILN8914XHawkins William A · Euless, TXN8915GFerdon Richard P Trustee · Fort Mohave, AZ
Back to AD 84-10-01 R1