AD 94-05-05 R1
Registered aircraft · 26,230
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.
N9244BSmith Simon K · Janesville, WIN9244UCairo Flying Club Inc · Cairo, ILN92454Durst Dylan S · Granbury, TXN9245BHitt Lonnie D · Gatesville, TXN9245UTaylor James R · Murfreesboro, TNN9246UArtemis Aviation Group LLC · Kalispell, MTN9248BJackalope Aviation LLC · Bellingham, WAN9249AZabowski Alan G · Belvidere, NJN9249BCoull Jennifer · Easton, PAN924FSGoodman Ryan · Vero Beach, FLN9251AMills Don T · Fairfield, CAN9251BBurke Charles M · Ocala, FLFirst renewal noticeN9251UCarpenter James M · Marion, ARN9252BSwain Raymond B · Mansfield, TXN9252UHoffman William C · Rostraver Township, PAN9254AHattell George Curtis · Olympia, WAN9254BMcdonald Daniel R · Las Vegas, NVN9256BDillard Wendell Hoyt · Centerville, TXN9257ULiberty Flyers Inc · Ramsey, MNN9258VTomczak Christopher · Intl Falls, MNN9259UAdirondack Legacy Aircraft LLC · Saratoga Springs, NYN9260UFlying L Aircraft Inc · Fort Denaud, FLN9261ACallahan Glenn P · Deridder, LAN9261UOconnor Sean P · Pompano Beach, FLN92620Goodrich Jeffrey W · Slaton, TXN9262UNichols Curtis E · Gloucester, VAN92643Leyde Dale R · Kent, WAN9265UEtchell Bruce R · Healdsburg, CAN9266ADyrstad Mary S · Hampshire, ILN9266UEgge Danny C · Pelican Rapids, MNN9267ABrown Craig A · Airway Heights, WAN9267UDavis Andrew P · Leominster, MAN92682Knefley J Michael · Ulysses, PAN9268UIbrahim Motaz · Goodyear, AZN9269ABriggs Aviation LLC · Virginia Beach, VAN9269BHaataja Charles M · Two Rivers, WIN927Qualitair LLC · MichelstadtN9270UYoung Orvel W · Maineville, OHN9271UWallis Bruce W · Kingwood, TXN9272BGyhra Bradley · Phenix City, ALN9274AOshinuga Anthony · Valley Center, CAN9276ABrandon Airways LLC · Bakersfield, CAN9276BKinberger Chris E · Louisville, KYN9277Lynn William S · Jackson, MSN9277ATibor W Farkas · Georgetown, TXN9277DBird Acquisition LLC · Phoenix, AZN9277UPeters Airway LLC · Pratt, KSN9278AHanna Mark W II · Pendleton, INN928Owls Head Transportation Museum · Owls Head, MEN9280BDreessen Steven C · Walkerton, IN
Back to AD 94-05-05 R1