AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N1163JBottom Line Aviation LLC · Scranton, NDN1164XRegistered aircraftN1165XLechtenberg Lance · El Dorado, KSN1165ZRegistration Pending · Las Cruces, NMRegistration pendingN1166ELake Jeffrey W · Steamboat Springs, CON1166LNovack Edward A · Cairo, NYN1166WFlight Operations Aircraft LLC · Wilmington, DEN11682Jahawk Leasing LLC · Sugar Grove, ILN1168LDepaul Thomas J · Juneau, AKN1168XJz Air LLC · Brooklyn, NYN1169HSwihart Matthew Allen · San Marcos, TXN116AJJewett Chris E · Lexington, SCN116BBretana Charles Jr · Prescott, AZN116BKDacy Roy W · Rockport, TXN116BWButler Ross W · Jackson, CAN116CWJazun Carlos Walter · Parker, CON116DHHoover David · Foster City, CAFirst renewal noticeN116DWWalters Douglas B · Templeton, CAN116GRegistration Pending · Sheridan, WYRegistration pendingN116GWMajestic Airlines Inc DBA · Lynden, WAN116JEAtp Aircraft 6 LLC · Wilmington, DEN116JMMorgan James E · Everett, WAN116JTParks Kevin J · Arlington, TNN116KSKent State University · Stow, OHN116LTMarrow Henry G · Southern Pines, NCN116MFWeber Donald E · Saint David, AZN116PGUnusual Attitudes LLC · Bates City, MON116QCigarroa Jorge J · Laredo, TXN116RCMiesch Gary D · Gowen, MIN116RJRegistered aircraftN116SB114b Holding Inc Trustee · Wilmington, DEN116SLXcel Aviation LLC · Eagle, IDN116SMArchie Aero LLC · Beaverton, ORN116TBMcmullan Francis G · Weirsdale, FLN116TSIrish Cindy L · Buckeye, AZN116VGBruns Phillip T · Shiro, TXN116VKAirborne LLC · Wilmington, DEN116ZXVranjes Peter · Johnstown, CON1170JHoward Thomas D · Bunnlevel, NCN1170LSweet Aviation LLC · Dover, DEN11723Rader Mark Todd · Deland, FLN11730Sendelbach John W · Cochrane, WIN1173CHolland Todd D · Mendota, ILN1173JCohelios LLC · Oviedo, FLN1173XWnc Aviation LLC · Arden, NCN1174JOlson Michael J · Viroqua, WIN11756Creswell Philip M · Camden, ALN1175ENannini Gary S · Lincoln City, ORN1176RBas Part Sales LLC · Greeley, CON1176TP C O Leasing Inc · Dobbin, TX
Back to AD 2006-10-21