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.
N53576Venbro Holdings LLC · Brooklyn, NYN53577New Horizon Aviation Inc · Warwick, RIN53587Chapel Hill Flying Club Inc DBA · Sanford, NCN5359KAbove And Beyond Aviation LLC · Austin, TXN535CHThibault Dominic · Titusville, FLN535EMCity Of Hawthorne · Hawthorne, CAN535EREmbry-Riddle Aeronautical University Inc · Prescott, AZN535HFPars Avn Corp · Wilmington, DEN535KSKent State University · Stow, OHN535VWAtp Aircraft 4 LLC · Wilmington, DEN53610Joe Wigginton Leasing LLC · Henderson, NVN53614Orange County Flight Center Inc · Santa Ana, CAN53636Sterling Flight Training · Jacksonville, FLN5363QCary Gosney Crna Inc · Sonora, CAN5363ZClover Park Technical College · Lakewood, WAN5364ABradley Flying Association · Peoria, ILFirst renewal noticeN536DDHughes Jacob · Denver, CON536EREmbry Riddle Aeronautical University Inc · Prescott, AZN536GRNational Aircraft Leasing Corp · Greenville, DEN536HFVan Anda Aviation LLC · Apopka, FLN536KSKent State University · Stow, OHN536LAhmed Ejaz DBA · Carrollton, GAN536NDPhoenix East Aviation LLC · Daytona Beach, FLN536SPEastern Cincinnati Aviation · Batavia, OHN536THLanier Equipment Leasing LLC · Gainesville, GAN537AMMazel Wings LLC · Camden, DEN537EREmbry-Riddle Aeronautical University Inc · Prescott, AZN537HFSilver Express Co · Miami, FLN537HPBarr Air Patrol LLC · Mesquite, TXN537KSKent State University · Stow, OHN537NDSpartan Education LLC · Tulsa, OKN537SAMills Michael R · Saratoga Springs, NYN537SP5280 Flying Club LLC · Castle Pines, CON538CPCivil Air Patrol · Maxwell Afb, ALN538EREmbry-Riddle Aeronautical University Inc · Prescott, AZN538HFSun Aircraft Management LLC · Ormond Beach, FLN538KSKent State University · Stow, OHN538NDAerosim Academy Inc · Sanford, FLN538SPRc Flying Partners LLC · Fair Oaks, CAN539CPCivil Air Patrol · Maxwell Afb, ALN539KSKent State University · Stow, OHN539MYMiller Aviation LLC · Murfreesboro, TNN539NDAerosim Academy Inc · Sanford, FLN53AAMustang Sally Aviation LLC · Camden, SCN53FFWingsleasing LLC · Wichita, KSN53FVTorres Ramon Luis · San Juan, PRN53KPMateos Louise M · Santa Clara, CAN53LULetourneau University · Longview, TXN540CFCertified Aviation LLC · Morristown, NJN540CPCivil Air Patrol · Maxwell Afb, AL
Back to AD 2003-24-13