AD 94-05-05 R1
Registered aircraft · 26,231
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.
N1520YScott Thomas A Jr · Lawrenceburg, TNN1521BAnderson Andrew A · Bates City, MON1522BHetrick Bros Inc · Orovada, NVN1522FMatray Blake E · Fairbanks, AKN1522YKinard Phillip · Tuscaloosa, ALN1523QKuharske Jeffrey · Groveland, FLN1523YRegional Air Inc · Lawton, OKN1524BBenger Scott C · Monument, CON1524QAnderson Anton E · Loves Park, ILN1526QTurpin George · Maquoketa, IAN1527YEshman Daniel J Jr · Bryan, OHN1528EBeasley Silas W · Spokane, WAN1528YTexoma Aero Club · Denison, TXN1529BSale Reported · Kennett Square, PASale reportedN1529YBirge Darrell W · Linden, INN152MLBright Trevis Lee · Marion, INN152PKDuby James C · Wellington, NVN152TJCopeland Robert C · Pahrump, NVN1530BAsleson James E · Intl Falls, MNN1530YCall Richard T · Wasilla, AKN1531BCoulter James Jon · Copperopolis, CAN1533BAirpower Museum Inc · Ottumwa, IAN1533KHancheck Paul C · Wadsworth, OHN1534BMacmahon Ian L · Osteen, FLN1534KShannon Randal S · Drexel, MON1534YLipsmeyer Jason K · Springdale, ARN1535YTheriault John · Harvard, ILN1536YCk Aviation LLC · Williamstown, NJN1537YAloha Skies Aviation LLC · Pahoa, HIN1538YPrice Andre D · Granger, INN153ABOchs Mark A · Madison, MSN153DACentral Virginia Aviation Inc · North Dinwiddie, VAN153JDMorgan Thomas R · San Antonio, TXN153PTGreen John · Yuba City, CAN153WSZeissner Douglas K · Chino, CAN1544BAdalias Family Farms LLC · Fort Pierce, FLN1545BMcmullen Morrell E · Angleton, TXN1546QInternational Air Services Inc Trustee · Carson City, NVN1547QAndersen Cameron T · French Gulch, CAN1547YBurgo Randy P · Alameda, CAN1549MRiggs James C · Wasilla, AKN1549YLotwala Pathik · Woodbine, MDN154BTDoser Lawrence · Macomb, MIN154DAOrr Lawrance C · Sacramento, CAN154DGFisher Jeffrey L · Thorndale, TXN154EShupe John D · Solon Springs, WIFirst renewal noticeN154SWHigh Mountain Properties LLC · Idaho Falls, IDFirst renewal noticeN154TBBerwick Robert G · Sonoma, CAN1552YRobinson Charles F · Beach City, TXN1553BGurley John A · Dania Beach, FL
Back to AD 94-05-05 R1