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.
N960AUAuburn University · Auburn, ALN960CPCivil Air Patrol · Maxwell Afb, ALN960CSCentury Equipment Co Inc · Salt Lake City, UTN960MSMt San Antonio Community College District · Walnut, CAN960TAInnoutaero LLC · Stockton, CAN961AUAuburn University · Auburn, ALN961BARobertson Breon J · Mc Allister, MTN961LTUniversity Of La System DBA · Ruston, LAN961RWBerchick Inc · Corrales, NMN962AUAuburn University · Auburn, ALN962CPCivil Air Patrol · Maxwell Afb, ALN962JBNational Aircraft Leasing Corp · Greenville, DEN962LTUniversity Of La System DBA · Ruston, LAN962PBNational Aircraft Leasing Corp · Greenville, DEN963ACYoung Paul J · Hudson, MAN963AUAuburn University · Auburn University, ALN963CPCivil Air Patrol · Maxwell Afb, ALN963EREmbry-Riddle Aeronautical University · Daytona Beach, FLN963JADeland Aviation LLC · Deland, FLN963LTUniversity Of La System DBA · Ruston, LAN963SPAero Aircraft 11 LLC · Jacksonville, FLN963TASvetfur Aviation LLC · Camden, SCN964AC63 Victor LLC · Fremont, OHN964AUAuburn University · Auburn University, ALN964CPCivil Air Patrol · Maxwell Afb, ALN964DAHeritage Aviation Management Ltd · Conroe, TXN964EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN964JRFvx Research · Manassas, VAN964LTUniversity Of La System DBA · Ruston, LAN964NWJpana Air Wa LLC · Seattle, WAN964SPDirty Side Down Aviation LLC · Georgetown, TXN964WFTempietto Inc · Aptos, CAN965AUAuburn University · Auburn University, ALN965BBBascom Kimber Keith · Mckinney, TXN965CPCivil Air Patrol · Maxwell Afb, ALN965CWAir Capital Aviators Club · Wichita, KSN965EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN965LTUniversity Of La System DBA · Ruston, LAN966ACWhiskey Charlie Aero LLC · Poway, CAN966AUAuburn University · Auburn University, ALN966CPCivil Air Patrol · Maxwell Afb, ALN966CSEvergreen III LLC · Renton, WAN966LTUniversity Of La System DBA · Ruston, LAN967CPCivil Air Patrol · Maxwell Afb, ALN967LTUniversity Of La System DBA · Ruston, LAN967MMMoney Multiplier Meridian LLC · Port Orange, FLN967SAElizabeth City State University · Elizabeth City, NCN9681Srividya Aviators LLC · North Brunswick, NJN9681FSplashdown Aviation LLC · Dunedin, FLN968CPCivil Air Patrol · Maxwell Afb, AL
Back to AD 2003-24-13