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.
N4323XRegistered aircraftN4323ZDubious Adventures LLC · Big Lake, AKN43240O'Quinn Kayla M · Jesup, GAN43241Atmospheric Vehicle & Spacecraft Flight Exploratio · Rch Palos Vrd, CAN43243Gomez Herbert · Holdenville, OKN43247Aircraft Guaranty Corp Trustee · Oklahoma City, OKN4324HTrott James E · Cathlamet, WAN4324JStaple K Aviation LLC · Queen Creek, AZN4324RShadle James A Jr · Gig Harbor, WAN4324VTriple Aaa LLC · Garden City, KSN4324WWhite River Trucking Inc · Mason, WIN4324ZBretts Spray Service Inc · Onida, SDFirst renewal noticeN43257P23 LLC · Edmond, OKN4325BWattum Joel W · Wasilla, AKN4325FIreland David · Eatonville, WAN4325JJpsc LLC · College Station, TXN4325QBeier Mark E · Sylvania, GAN4325RGaruda Aviation Inc · Miami, FLN4325TBledsoe Randell W · Springtown, TXN4325UMetro Aircraft Co · Bloomington, MNN4325VArcher Assoc LLC · Ashburn, VAN43263Healey Terrance P · Redding, CAN43266Sky High Helicopters LLC · Camarillo, CAN43268Inter Global Aviation LLC · New Fairfield, CTN4326CSeven Echo Whiskey Corp · Wilmington, DEN4326JHayes Barrett W · Siler City, NCN4326LN4326l LLC · Senoia, GAN4326NLikakis John M · Bennington, VTN4326QStar Fleet Aviation LLC · Bisbee, AZN4326ZSuchland Simon K · North Pole, AKN4327ACasten Scot R · Vernonia, ORN4327JDowling Investments LLC · Gillette, WYN4327MDestiny: Success LLC · San Luis Obispo, CAN4327PKing Air Inc · Naknek, AKN4327QFackler Aviation Services LLC · Clearwater, FLN43287Carlucci Peter M · Pittstown, NJN43289Prickett Terry L · Albertville, ALN4328AHubert Matthew J · Fremont Center, NYN4328HCalabretta Charles J · Hanford, CAN4328JWeldon Thomas · Marysville, OHN4328NTalker Albert · Stroudsburg, PAN4328QBetzner John C · Medway, MAN4328TWhite Mickey S · Hyrum, UTN4328XWhitehair Donald N · Stevensville, MTN4328ZWilmarth Rebecca C · Red Devil, AKN43291Etheredge Mark · Pell City, ALN4329FStrathman Aerial Spraying LLC · Axtell, KSN4329MByrne Matthew A · West Allis, WIN4329PDunn Danvil L · East Meadow, NYN4329QElfers Brian K · Colfax, WAFirst renewal notice
Back to AD 2007-04-19 R1