AD 2003-24-13
Registered aircraft · 7,870
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:2003-24-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-24-13')
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:2003-24-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-24-13') 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.
N919WCCarroll Walter · Villa Hills, KYN919ZATextron Aviation Employees Flying Club Inc · Wichita, KSN91CSSkye Furniture Inc T/A Sky Aviation · Mechanicsville, VAN91CYVan Bortel Aircraft Inc · Arlington, TXN91FFFf22 LLC · Scottsdale, AZN91FRJanie Air Inc · Roseville, CAN91FSEastern Kentucky University · Richmond, KYN91HAHoneybee Air LLC · Newark, NJN91PFSkyline Solutions Inc · Deland, FLN92004Oklahoma State University · Stillwater, OKN9200BChristiansen Aviation LLC · Wilmington, DEN9202UOklahoma State University · Stillwater, OKN920BWWilliams Rebecca J · Alto, NMN920CFWingsleasing LLC · Wichita, KSN920CPCivil Air Patrol Inc · Maxwell Afb, ALN920CYAircraft Trustee Services Inc Trustee · Dover, DEN920EPEpic Aviation Inc · New Smyrna Beach, FLN920MAPerry Castonguay Farms Inc · Omega, OKN920MTAcron Aviation Academy Inc · Sanford, FLN920NCState Of North Carolina · Raleigh, NCN920TAAtp Aircraft 4 LLC · Wilmington, DEN920WBJet Air Inc · Iowa City, IAN921BBNorthwestern Michigan College · Traverse City, MIN921CTN921ct LLC · Elkton, KYN921EZAircraft Guaranty Corp Trustee · Oklahoma City, OKN921KSWilliams Scott Thomas · Lake Havasu, AZN921LSNg Research · Manassas, VAN921PJbt Legacy LLC · Ocklawaha, FLN921TAAtp Aircraft 4 LLC · Wilmington, DEN921UN921un Ventures LLC · Mercer Island, WAN92228Dhs Operations LLC · Wilmington, DEN9222HDhs Operations LLC · Wilmington, DEN9223CDhs Operations LLC · Wilmington, DEN9223EDhs Operations LLC · Wilmington, DEN9223XDhs Operations LLC · Wilmington, DEN92264Dhs Operations LLC · Wilmington, DEN92266Dhs Operations LLC · Wilmington, DEN9229FCooke John W III · Carthage, TXN922BCTanaka Akira · Torrance, CAN922CPCivil Air Patrol · Maxwell Afb, ALN922CSWorm Rudolf Heiko · Saint Petersburg, FLN922LHClover Park Technical College · Lakewood, WAN922MKNational Aircraft Leasing Corp · Greenville, DEN922TAAtp Aircraft 4 LLC · Wilmington, DEN9230YDhs Operations LLC · Wilmington, DEN923AZN923az LLC · Miami, FLN923CPCivil Air Patrol · Maxwell Afb, ALN923CSGlobal Aircraft Leasing Inc · Wilmington, DEN923CTBragdon Emil · Fort Worth, TXN923DBGrenville Andrew · Decatur Island, WA
Back to AD 2003-24-13