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.
N45RAHurula Jeffrey J · Drummond, WIN45RVCullen Patrick J · Dayton, OHN45RWAsman Sanford J · Atlanta, GAN45SLWebb Aviation LLC · Watonga, OKN45SNSchlosser Phillip L · Rehoboth Beach, DEN45SSOshinuga Anthony A · Valley Center, CAN45SVHereford America Inc · Reva, SDN45TAMichalek Construction Inc · Keosauqua, IAN45TBGooney Bird Group Inc · Templeton, CAN45TDDiers Robert D · Fremont, NEN45TFWave Transportation LLC · Middletown, DEN45TSMcalee Patrick Jason · Chicago, ILN45TZCumberland Kelly E · Woodbine, MDN45UDAlf Ix LLC · Chicago, ILN45USFlight Operations LLC · Hollister, MON45VCHoyos Luis F · Fort Pierce, FLN45VFTaylor Bryan E · Waco, TXN45WBDfw Aero Mechanix Inc · Oak Point, TXN45WCClark John A · Louisville, MSN45WDBenham John D · Blanco, TXN45WRUso Security Inc · Chino, CAN45WWHolmes Bruce Arthur · Maricopa, CAN45XDSubstation Air LLC · Midvale, UTN46001Df Kitcar LLC · Red Oak, TXN46003Carroll Michael L · Rochester, WAN46007Aircraft Builders Associates LLC · Tempe, AZN4600BKlyde Jeremy M · Irvine, CAN4600JDavis Robert M · Dallas, NCN4600SCozzolino Aerosports II LLC · Indianapolis, INN4600UDlw Aviation LLC · Missoula, MTN46011Jackson William T · Clinton, OHN46015Leaders Flying Service LLC · Clear Lake, MNN46019La Porte Aero Club Inc · La Porte, INN4601BArnavair LLC · Pearland, TXN4601ETen Two Holdings LLC · Somers, MTN4601GResicum International LLC · Gulf Shores, ALN4601JHardin John M · Terrell, TXN4601UChin-Loy Christopher Wayne Trustee · Tamarac, FLN4601VDuffys Aircraft Sales & Leasing Inc · Neillsville, WIN4601WMike Papa LLC · Newton, KSN4601XMast Aviation LLC · South Boston, VAN46024Garfield Joshua E · Tampa, FLN46027Cleary Thomas J · Fairport, NYN46028First Take Aviation LLC · Van Nuys, CAN4602JNew Garden Township · Landenberg, PAN4602SKeniston Kimberly A · Tyngsboro, MAN4602WBrugueras Ralph Steven · Deer Park, WAN46030Constance Air LLC · Luthersville, GAN46031Soucy Gary J · Brewer, MEN4603BMonroe Frank B · Reno, NV
Back to AD 2007-04-19 R1