AD 94-05-05 R1
Registered aircraft · 26,232
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N5792TMorgan Dennis A · Middle River, MDN5793CDobyns Jesse · Ethel, WAN5793ELowe David M · Sacramento, KYN5793RRogers Jesse E · La Belle, MON5793TJefferson County Public Schools · Louisville, KYN5794APerkins Larry L · Wildomar, CAFirst renewal noticeN5794RMacfarland Donald C · North Tonawanda, NYN5794TGodfrey Kenneth E · Oroville, CAN5795ERose Walter W · Arena, WIN5795GRhodes Tom B · Dallas, TXN5796CJohnson Terry A · Idaho Falls, IDN5797AEver Fast LLC · Kalispell, MTN5797CNorris Terry F · Rockford, ILN5797RRiggs Laura A · Middleburg, FLN57984Jacobi Joseph · Mexico, MON5798ABowman Ronald J · Bellefonte, PAN5798EPineapple Flyers Inc · Rockville, MDN5798RRatcliff Bruce A · Plain City, OHN5799AMiller Lavon S · Eureka, NVN5799CLewellen Donnie J · Friona, TXN5799GBafa LLC · Lewes, DEN5799TGs Air LLC · Sioux Falls, SDN579CCLape Bruce A · Kasilof, AKN579KRed Plane Aviation LLC · Key West, FLN579MAJones Andrew W · Turner, MTN579MGHaas Sean Francis · Yucca Valley, CAN57EZRhinehart Wendell E · Cape Coral, FLN57LGSavier Klaus H · Santa Paula, CAN57MWFogal Brian K · Chambersburg, PAN57NDelash John M · Williamson, GAN57PCCutler Robert H · Denison, TXN57QMowad John · El Paso, TXN57RMIsberg Weston T · Rancho Murieta, CAN57TDWock Duane A · Helena, MTN57TLMickel Timothy R · Freeport, ILN57WKStocker James M · Palmer, AKN5800ACarson A Jane · Vance, ALN5800CFreixas Enrique · Torrance, CAN5800RPomeroy Cattle Ranch LLC · Kalispell, MTN58029Bruhn Alexander · Naples, FLN5802EMcdougall James R · Las Vegas, NVN5802RMiller Chris D · Collierville, TNN5804ASandall Evan R · Bonsall, CAN5804EAncona Edward T · Altadena, CAN5804GSkylands Air LLC · Port Orange, FLN5804RGriffin David Charles · Palmyra, PAN5805AVictory Aero Tech Inc · Camarillo, CAN5807RYoung Darrin · Chillicothe, MON5808GMoncrieffe Ainsworth L · Aurora, CON5809RJ L S Agency LLC · Starkville, MS
Back to AD 94-05-05 R1