AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N4036RN4036r LLC · Quinton, ALN4036ZHockey Puck LLC · Big Lake, AKN40372Gajewski Lillia M · Billings, MTN40374Solo Exteriors Co LLC · Seminole, TXN4037EMathews Brett G · Platte City, MON4037GN4037g LLC · Lecanto, FLN4037MJensen Mitchell D · Coeur D Alene, IDN4037PLivernois Douglas H · Melrose, FLN4037YVfr Ltd · Wilmington, DEN4038BHarris James Thomas · Churubusco, INN4038DSkydive Snohomish Inc · Snohomish, WAN4038MAlyeska Helicopters LLC · Girdwood, AKN4038WCharlie Delta Rotors Inc · Coral Gables, FLN4038ZLutz Matthew S · Lewistown, MTN40398Emerald City Aircraft Leasing Inc · Port Orchard, WAN4039BParish Aviation LLC · Earth, TXN4039DKruger Daniel G · Stateline, NVN4039PPetersen Clayton L · Albert Lea, MNN4039ZMeeker Airport Inc · Meeker, CON403ABItalio River Adventures LLC · Yakutat, AKN403AJAero Jet Aviation I Inc · Fort Lauderdale, FLN403ATNew Horizons Aviation Inc · Goshen, INN403BCSmith Kenneth W · Marble Falls, ARN403CACivil Air Patrol · Maxwell Afb, ALN403CDSma Air LLC · Lindstrom, MNN403CPGreenblatt Steven · Macon, GAN403CTCat Aviation LLC · Big Sky, MTN403CVCivil Air Patrol · Maxwell Afb, ALN403DM403dm LLC · Indianapolis, INN403DTTimms Douglass D · Gouldsboro, MEN403EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN403ESPlumdaffy LLC · West Chatham, MAN403FDFrancesco Tedeschi · Del Mar, CAN403GFSky Mates Inc · Wilmington, DEN403GMBalisky Micah · Fort Shaw, MTN403JREllman Brett M · Cardiff By The Sea, CAN403LDUngerecht Lyle · Independence, ORN403LLTech Heli LLC · Fort Lauderdale, FLN403NAWadsworth Chad C · Lake Havasu City, AZN403PKN403pk LLC · Ada, MIN403RRodrian James A Trustee · Grafton, WIN403RCSalt Lake Community College · Salt Lake City, UTN403RMUlpiano Amy L · Carolina, PRN403SWheeler James · Shreveport, LAN403SACalk Mark C · Troy, ALN403SHAustin Peay State University · Clarksville, TNN403SPHillsboro Aero Academy LLC · Hillsboro, ORN403SSSausen Michael C · Hortonville, WIN403SWBsf Skylane LLC · Buford, GAN403WAAviatech Inc · Tamarac, FL
Back to AD 2007-04-19 R1