AD 2001-20-01
Registered aircraft · 2,521
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:2001-20-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-20-01')
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:2001-20-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-20-01') 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.
N162GAPa1 208b-0667 LLC · Fort Lauderdale, FLN162MCBank Of Utah Trustee · Salt Lake City, UTN162QMartin Foundry Service Inc · Glencoe, ALN163KAAdvanced Global Services Inc · Vero Beach, FLN1655MMichigan Aeronautics Commission · Lansing, MIN165TGAmj Aviation LLC · Oneida, TNN165YVAlpine Aviation Inc · Provo, UTN166CLKa Partners LLC · Thomson, GAN166DHRandigo LLC · Wilmington, DEN166LAAeronautical Technologies Inc · Clovis, NMN166SAClear Skies Ltd · Cincinnati, OHN167BBCentral Virginia Aviation Inc · Petersburg, VAN168CWXu Zhaohui Executor · Memphis, TNFirst renewal noticeN168LMArne Aviation LLC · Suffolk, VAN168MARunway Vineyards LLC · Santa Maria, CAN168RFRandigo LLC · Wilmington, DEN169BADesert Sand Aircraft Leasing Co Inc · Rosharon, TXN169GLAlpine Aviation Inc · Provo, UTN16HGBear Air LLC · Mount Vernon, INN16KWWild Blue Aviation LLC · Wilmington, DEN16TBEager Beaver LLC · San Diego, CAN16TMTriad Physician Resources Inc · Longview, TXN170GLAlpine Aviation Inc · Provo, UTN170JCWlgb200 LLC · Reno, NVN171GCRigidworks LLC · Anaconda, MTN171SCotterkey N171s LLC · Phoenix, AZN173KSCentralav LLC · Lake Worth, FLN175LAMitchell Andrew D Trustee · Winnie, TXN175SAGeneral Atomics · San Diego, CAN175WBHerdair Group LLC · Conroe, TXN176YVHill Air Executive Inc · Fort Pierce, FLN177CNRca Aviation 2 LLC · Tempe, AZN177LACabeza De Vaca Holdings LLC · Carrollton, TXN177RAUnited States Government · Fort Belvoir, VAN1789MMjr Aviation Consultants LLC · Clearwater, FLN178YVAlpine Aviation Inc · Provo, UTN179MDGem City Properties LLC · Laramie, WYN179SAPriority Air Charter LLC · Kidron, OHN17KKRiverbend Aviation LLC · Hernando, MSN17LHHigh Flying Investments LLC · Texarkana, ARN17YLYowell Legacy Aviation LLC · Killeen, TXN180AVAdams Aviation Services Inc Trustee · Wilmington, DEN180GCZuni LLC · Kirkland, WAN183CTUltimate Resort Vacations Inc · Weston, FLN183SADriscoll David A · Savannah, TNN18471Chase Air LLC · Montgomery, ALN1848ST&T Air LLC · Lindsay, OKN184AEN184ae LLC · Ault, CON184UXAlpine Aviation Inc · Provo, UTN186DCAir Care Inc · Lamar, CO
Back to AD 2001-20-01