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.
N4874QSutton Aircraft Salvage LLC · Palmer, AKN4874SShores Financial LLC · Thayer, ILN4874TSmith Richard R Sr · Wellington, NVN4875DNightwing Productions LLC · Aptos, CAN4875FVan Kirk Ronald · Wichita Falls, TXN4875JBeech Bound Aviation LLC · Bartlett, TNN4875KHolland Karey Lynn · North Plains, ORN4876DAcute Holdings LLC · Jenks, OKN4876FCosta Air Service LLC · Painted Post, NYN4876GKing Bryan A · Austin, TXN4876TAyers Terry · Boise, IDN4876UCottrell Seth M · Kenai, AKN4876VGrothe Loren L · Willmar, MNFirst renewal noticeN4876YCarson Engineering And Manufacturing Inc · Springdale, ARN4877BHardman Kyle B · Shady Shores, TXN4877DAviator Air Flight School LLC · Grand Prairie, TXN4877JR&R Aero Services LLC · Eden Prairie, MNN4877LTxp Designs LLC · Jasper, INN4877SRegistered aircraftN4878AMallek Edward J · Fairbanks, AKN4878DCache La Poudre LLC · Fairfield Bay, ARN4878FNistler Gabriel R · Helena, MTN4878LPeg Aviation LLC · Cedar Hill, TNN4878QRichter Patrick A · Edna Bay, AKN4878SGarmin International Inc · Salem, ORN4878TLorbiecki John E · Hubertus, WIN4878Y182b LLC · La Plata, NMN4879DMorey Airplane Company Inc · Middleton, WIN4879FCitizen Air LLC · Port Angeles, WAN4879KNorthwest Navion Inc · Arlington, WAN4879SWilliams Michael J · Mount Laurel, NJN4879TCombs Kenneth E · Canyon, TXN487AArcher Aircraft LLC · Wilmington, DEN487BLBlue Line Aviation LLC · Smithfield, NCN487ERCloudchasers LLC · Colorado Springs, CON487FLCarr Richard L · Cameron, WIN487HPAlpha Niner Niner LLC · Winter Garden, FLN487KMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN487PLoehrer Michael A · Saint Cloud, MNN487PANipp Michael · Nampa, IDN487SCRegistered aircraftN487SPArchimedes Aviation LLC · Livermore, CAN487TPridmore Sammy D · Tahoka, TXN487WBRice Leslie G · Berthoud, CON4880DBernstein Timothy D · Faith, SDN4880FFkm Air Shuttle LLC · Brooklyn, NYN4880GCifelli George J · Dothan, ALFirst renewal noticeN4880LHigginbotham Rome A · Zanesville, OHN4880NFront Porch Air LLC · Dalton, GAN4880TItechtives Company LLC · Purcellville, VA
Back to AD 2007-04-19 R1