AD 2002-07-01
Registered aircraft · 3,466
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:2002-07-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:2002-07-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:2002-07-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:2002-07-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.
N5516CCarson Kirk · Dalhart, TXN5517UKoegel John C · Flint, MIN551JBValiair Lc Trustee · Casper, WYN5523YSimmons Scott · Anchorage, AKN5525USheriffs Department · Oakland, CAN5528AWarden Hutterian Brethren · Warden, WAN5531ASouther Field Aviation Inc · Americus, GAN5537CM G Aviation · Tyler, TXN5538YTeton View Aircraft Leasing LLC · Grass Valley, CAN5549AGeoterra Inc · Eugene, ORN5550YSteiner Paul R · Boerne, TXN5555GSinton Frank J · Durango, CON5555SSky West Aviation Inc Trustee · Albuquerque, NMN555RCCaron Robert M · Fort Pierce, FLN555RYA-1 Windshield Inc · Rexburg, IDN555SKJld Resources Management LLC · Helena, MTN559TTMcdonald Aviation Mgt LLC · San Jose, CAN55EUC L Holdings LLC · Washington, DCN55RHMccarthy Michael E · Martinez, CAN55RXJs Enterprises LLC · Clarinda, IAN5620GWilliams Dean Nelson · San Antonio, TXN562DGB2d LLC · Wickenburg, AZN565CMBackcountry Aviation LLC · North Salt Lake, UTN565RAN565ra LLC · Elbert, CON567DEclipse Inc · Sharon Springs, KSN567DTCenturion Aviation Inc · Kalispell, MTN567JGRapid River Aviation LLC · Boulder City, NVN568HBKurreck Tim R · Caldwell, IDN56AKLonghorn Leasing LLC · Anchorage, AKN56BPCeballos Oscar Felipe · San Ysidro, CAN56DCAero Services Lc · Woods Cross, UTN5706JTaylor Larry D · Meridian, IDN5712JFree Air LLC · Helena, MTN5716JTaos Sky Flight School LLC · El Prado, NMN5731JPaulick Adam J · Deerfield, WIN5743JMidwest Aerial Photography · Galloway, OHN574STState Of Alaska · Anchorage, AKN5751JB & H Drilg · Winnsboro, LAN5755GDestination Alaska Air Service LLC · Homer, AKN5757JAdams Gary A · Alva, OKN5762JJonesco Acquisitions LLC · Bixby, OKN5763JLemons Brooks D · Visalia, CAN5767JValiair Limited Co Trustee · Casper, WYN5768JHaag Walter G · Fall City, WAN5771JRegistered aircraftN5779JBeavers Air LLC · Fort Walton Beach, FLN577CDSeger Properties Ltd · Fort Loramie, OHN5783JSelting Mark D · Kadoka, SDN5796JRegistered aircraftN57977Denney Dennis · New Port Richey, FL
Back to AD 2002-07-01