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.
N444AFContinental Aero Associates Inc · Grosse Pointe Park, MIN444AJAj2 Air LLC · Arroyo Grande, CAN444AWHangar 22 LLC · Wilmington, DEN444BDAddington James T · Denton, TXN444BJLelouis Michael P · Sacramento, CAN444BLTri Air LLC · Monette, ARN444BRNational Aviation Academy Of Mississippi Inc · Clearwater, FLN444BSSiemens Christopher L · Seminole, TXN444BUHelifun Expeditions LLC · Kalispell, MTN444BWAmigo Helicopter Services LLC · Falfurrias, TXN444BZWilliams Allen G Jr · Fort Worth, TXN444CCVon Almen James Martin · Lewisburg, TNN444CHSouthport Aviation Inc · Hephzibah, GAN444CJAms Company Inc · Cleburne, TXN444CLK G L Aviation Inc · Villisca, IAN444CPMercure Ryan K · Eads, TNN444CRUtah State University · Logan, UTN444CSStover Charles S · Ft Lupton, CON444CTLeseviciute Audrone · Stamford, CTN444DBBalint Jozef · Fort Worth, TXN444DDHardin Donald D Trustee · Kirkwood, MON444DGSwanson Douglas A · Marana, AZN444DJSims George W III · Eclectic, ALN444DMGosnell Josh W · Richards, TXN444DPStratospheric Ventures LLC · Saint Petersburg, FLN444DTBagdasarian Walter DBA · El Cajon, CAN444DVSky High Helicopters LLC · Camarillo, CAN444DWTriple 4 Dw LLC · Davie, FLN444EEVaughn Stewart C · West Jordan, UTN444FRegistration Pending · Auburn, CARegistration pendingN444FCCentric It Resources LLC · Loomis, CAN444FDJohnson Heimana J · San Marcos, CAN444FEN444fe LLC · Stuart, FLN444FGFrancis Andrew J III · Spring, TXN444FRRainier Flight Service LLC · Renton, WAN444FWKuntz Clark · Tallahassee, FLN444GCCampbell Gregory A · Davis, ILN444GENeverland LLC · Emerson, IAN444HGHigher Ground Helicopters Of Cincinnati LLC · Miamisburg, OHN444HHAircraft Management Group Intl Corp Trustee · Wilmington, DEN444HKChurch David H · Albuquerque, NMN444HSCampi Curtis A · Boulder City, NVN444HTTaktos Ltd · Corvallis, ORN444HUDorsey Sage · Bend, ORN444HYHutton Mark · Denison, TXN444JGGrimmonpre Mark D · Fort Walton Beach, FLN444JLColby Christopher F · Hampton, VAN444JMPeck Joseph A · Pound Ridge, NYN444JTFilho Aniz Rasslan · Payson, AZN444JYSchwarzenberg Johannes · Helena, MT
Back to AD 2007-04-19 R1