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.
N7884NUnited States Air Force Owner · Usaf Academy, CON7884THyde Russell M · Rutherfordton, NCN7884ZFrenkel Amotz · Las Vegas, NVN78850Karpik Richard Paul · Grand Rapids, MNN78856Bedwell Christopher A · Paso Robles, CAN78857Hunt Thornton Trevon · Aurora, CON7885TSmith William B · Marcola, ORN7885USchlick Caleb Mcwilliam · Deweese, NEN7885ZGonzales Donald M · Columbia Station, OHN7886GArctic Barnabas Ministries Inc · Kenai, AKN7886NLake Area Technical Institute · Watertown, SDN7886TCobb John R · Boynton Beach, FLN7886UStevenson David E · Grundy, VAN7887FSwearingin Curtis A · Carrollton, MON7887GLandrum Erik · Austin, TXN7887NUnited States Air Force · Kirtland Afb, NMN7887UShaner Ervin Craig · Willow Spring, NCN7888TMyers Jay R · Delavan, WIN7889GFricker Mark W · Avon, INFirst renewal noticeN7889NDutchess Community College · Poughkeepsie, NYN7889THele Lani LLC · Mililani, HIN7889ZSmith Donald J · Granite Falls, WAN788BTPowers Elbie L · Roseboro, NCFirst renewal noticeN788CPCivil Air Patrol · Maxwell Afb, ALN788FAAb Prop Plane II LLC · Metairie, LAN788FTSt Louis Flight Training LLC · Cahokia, ILN788MCRoberts James A · Edina, MNN788MKRabin Michael D · Charlottesville, VAN788PWilliam Earl Dixon LLC · Lumberton, NCN788RMVan Bortel Aircraft Inc · Arlington, TXN7890ARobinson Stephen K · Davis, CAN7890EShogren Marina L · Fort Pierce, FLFirst renewal noticeN7890FScholz Francis M · Atchison, KSN7890GAltus Aircraft LLC · Taylor, TXN7891GSam Aviation LLC · Long Beach, CAN7891NUnited Statesair Force · Travis Afb, CAN7891TDonaldson Robert M · San Ramon, CAN7891UCessna 150 152 Fly In Foundation · Springfield, VAN7892EFox Stephen A · Wasilla, AKN7892UAirtime Aviation LLC · Cabot, ARN78938Wings Over Texas Holdings LLC · Denton, TXN7893FBrowett Donald · Independence, MON7893GRegistration Pending · Bucyrus, OHRegistration pendingN7893UMiller Bryan L · Somonauk, ILN7893ZThompson Raymond V · Westwego, LAN7894EMou Air Group LLC · Kalispell, MTN7894GAr Aero Services LLC · Sacramento, CAN7894TGriggs Howard D · Crestline, CAN7894UPetty Robert J · Carson City, NVN7895FBrock Michael G · New Lenox, IL
Back to AD 79-10-14 R1