AD 82-23-01 R1
Registered aircraft · 3,118
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:82-23-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:82-23-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:82-23-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:82-23-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.
N7111YBritt Robert J · Au Gres, MIN7112PNouri Kamyar · Fullerton, CAN7113PWallace Lonnie Roy · Charlotte, NCN7114PP & G Aviation LLC · Omaha, NEN7114YAymerich Marc · Belvedere, CAN7115YMcdade Nimrod R III · Smyrna, TNN7116YSinclair Air LLC · Shallowater, TXN7117PRegistration Pending · Sandia, TXRegistration pendingN7118PSuarez Aaron M · La Habra Heights, CAN7119YFlydunn.Com Inc · Jacksonville, FLN711BAPresley Louis · Cresson, TXN711BWQualitair LLC Trustee · MichelstadtN711EEBrunson Douglas H · Burnet, TXN711EWWard Lumber Company Inc · El Cajon, CAN711KKRegistered aircraftN711SGGullo Santo · Ponce Inlet, FLN711TANorth Star Equipment LLC · Simms, MTN7120YRoyal Ryan M · Lincoln, NEN7121YUhlemeyer William A · Alvin, TXN7122YSutton Jack M · Jesup, GAN7123PMclenaghan Alvain N · Phoenix, AZN7124PTalley John T · Clifton, TXFirst renewal noticeN7125PHernandez Jimmy Lee · Lamesa, TXN7126GHenry Rolla G Jr · Saint Charles, MON7127YSpencer Avionics Inc · Spencer, IAN7128PRegistered aircraftN7128YAir Mods And Repair Corp · Robbinsville, NJN7129YButner Gary W · Yuba City, CAN7130PRieman Joel · Lompoc, CAN7130THeffron Jacob L · Little Falls, MNFirst renewal noticeN7131YGreat Lakes Air Ventures LLC · Mason, MIN7132PJordan Kevin · Lander, WYN7134PHayduk International LLC · Rockhill Furnace, PAN7135CBoss Gary W · Bronston, KYN7136YSchilling Stephen V · Rockford, ILN7138PHickman Marcus · Fort Worth, TXN7139PPendlay Heath V · Kalispell, MTN713JRO Reilly Robert · Houston, TXN7141PWild Aire LLC · Wilmington, DEN7142PCorbets Jeffrey B · Santa Clarita, CAN7143PKc Flyers Inc · Wilmington, DEN7144PAllis Frederick M · Eden Prairie, MNN7145PAstraeus Lc · Evanston, WYN7146PRichardson Eeseh A G · Loganville, GAN7147YLee A Archer Jr Red Tail Youth Flying Program Inc · New Windsor, NYN7150PPickerill Robert L · Hopkinsville, KYN7153PKnutson Daniel T · Lodi, WIN7155YSheasley George · Eagle Creek, ORFirst renewal noticeN7156PWeinzapfel Joe M · Muenster, TXN7157YTailwind Consulting LLC · Port Orange, FL
Back to AD 82-23-01 R1