AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.
N66333Registration Pending · Cooksville, MDRegistration pendingN6633AKolp Mark H · Andrews, TXFirst renewal noticeN6633SRegistered aircraftN66349Kecy Kevin · Owls Head, MEN6634AKallabis Harry · Camino, CAN6634EWinkles Ron M · Ardmore, OKN6634TBensaida Said · Hawarden, IAN6635ALewis John · Abbyville, KSN6635FJenkins Keith · Corralitos, CAN6635SCoughanowr David D · Chatham, MAN6635XNewsom Larry E Jr · Hernando, MSN6636FChesterton Thomas W Jr · Watertown, MAN6636XAllen Leigh E · Bedford, WYN66376Backhaus John W · Hampton, NHN66379Curry Zachary A · Loveland, CON6637ASmedley Hank W · Lake Havasu City, AZN6637TRomo Aubrey J · Del Norte, CON66380Logan Thomas H · Canfield, OHN66383Tuskegee Airmen National Historical Museum · Detroit, MIN66384Anderson Rick L · Valley City, NDN66386Registration Pending · Portage, MERegistration pendingN66387Bredvold Daniel M · Mendota Heights, MNN6638AKeystone Cessna LLC · Melrose, FLN6638MAdams Flying Service Inc · Rayville, LAN6638NIsr Aviation LLC · Wilmington, DEN6638TSmolios Charles M · Nashville, TNN6638XSipple Paul K · Moorpark, CAN66393Dash Roger A · Niles, MIN66394Y&S Aviation LLC · Oceanside, CAN66395Murray Kevin D · Moneta, VAN66397Petersen Bradley L · Bellingham, WAN66399Acord Aviation Co L L C · Chandler, OKN6639APeach Christopher G · Waterville, MNN6639SMoen Richard C · West Dundee, ILN6639XLee Michael A · Arlington, WAN663CPCivil Air Patrol · Maxwell Afb, ALN663GGNt Miller LLC · Winchester, KYN663RTRaiders Tigers Flying Club Inc DBA · Houston, TXN663SPN663sp LLC · Stuart, FLN66402King Dwayne W · Sutton, AKN6640ABunger Glenn H · Kirkland, ILN6640ELarkin Marion J · Salome, AZN6640FFlying High LLC · Gore, VAN6640GKruckeberg Leroy A · Sanford, NCN6640HSolis Aviation LLC · Carroll, OHN66412Farris Chad M · Bronte, TXN6641FKatzenberger Devin T · Little Falls, MNN6641GWalborn Carl L · Sun City, AZN66420Ware Charles W Jr · Atmore, ALN66422Zaleski-Johnson Laura · Mays Landing, NJ
Back to AD 79-10-14 R1