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.
N552CDDirect Internet Inc · Harsens Islands, MIN552CMCm552 LLC · Katy, TXN552DMRedstone Aero LLC · Chesterfield, MON552DSFlying Pup Adventures LLC · Missoula, MTN552KMPrecision Flying LLC · West Chester, OHN552LELeading Edge Flight Academy LLC · Bend, ORN552MTGlacier Cub LLC · Whitefish, MTN552NDOdegaard Wings Inc · Kindred, NDN552PCSaint Louis University · Saint Louis, MON552PUSkyborne Airline Academy Inc · Vero Beach, FLN552RVRegistered aircraftN552RWWelch Richard L · Tazewell, TNN552SPEngineers Flying Club Inc · Bethany, OKN552WTMaierhoffer Henry F Jr · Sylvania, GAN552ZSTuolumne Ridge LLC · Modesto, CAN55301Registered aircraftN55302Coastl Air Inc · Groton, CTN55303Cullum Phillip R Jr · San Tan Valley, AZN55304Brittle Aviation LLC · Chapel Hill, NCN55305Berry Mitchel R · Chatfield, MNN55308Charger 308 LLC · Hollis, OKN5530BInternational Air Services Inc Trustee · Carson City, NVN5530ERovey Land & Cattle Co · Parker, AZN5530JSellers Justin Kennedy · North Augusta, SCN5530WHobgood Sidney · Klamath Falls, ORN5530XFaulhaber Orlin W · North Platte, NEN55310Monarch M Miller · Cloverport, KYN55311Aeras Transport LLC · Lewes, DEN55313Dunning Mark · Chino Hills, CAN55315Norman Eric Lee · Hilton Head Island, SCN55317Schwader Aviation LLC · Saint Joseph, MON55319Guckin Michael E · The Villages, FLN5531BNighthawk N8231g LLC · Granite Bay, CAN5531FSchmidt David D · Atlantic Mine, MIN55320Dragon Flight Training Academy LLC · Pembroke Pines, FLN55325Hater Michael A · Cincinnati, OHN55327Grise Paul R · Hopkinsville, KYN5532DSchaffert Warren E · Trenton, NEN5532JRegistration Pending · Trinity, FLRegistration pendingN5532PHoudek Todd L · Roseburg, ORN5532SAks Aviation LLC · Arroyo Grande, CAN5532UGorman Jeremy J · Chapman, KSN55330Eaw Aviation LLC · Middletown, MDN55331Scholl Oil & Transportation Company · Holyoke, CON55338Pt Arts LLC · Grand Rapids, MIN5533DKilo Aviation LLC · East Peoria, ILN5533EEnergy Transfer Aviation LLC · Spring, TXN5533FCopenhaver Ralph L · Brady, TXN5533KVan Nostran Michael T · Lake Havasu City, AZN5533PRado Richard L · Fortville, IN
Back to AD 2007-04-19 R1