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.
N669DMDaniels Tree Service Inc · Taylors, SCN669EREmbry-Riddle Aeronautical University Inc · Prescott, AZN669FGMustang Sally Aviation LLC · Camden, SCN669PDBarder David A · Millersburg, PAN669TWAlmanor Express LLC · Palo Alto, CAN66FRBledsoe James C · Hugo, CON66HERausch William Donald · Ontario, NYN66LYRapid Fleet II LLC · Carmel, INN66TSTall Timber Flying Service LLC · Kalispell, MTN670CSSilverhawk Aviation Academy LLC · Caldwell, IDN670EREmbry-Riddle Aeronautical University Inc · Prescott, AZN670MAVan Anda Aviation LLC · Apopka, FLN671EREmbry-Riddle Aeronautical University Inc · Prescott, AZN671MAVan Anda Aviation LLC · Apopka, FLN672CPCivil Air Patrol · Maxwell Afb, ALN672EBAviation Associates Of Hanover LLC · Enfield, NHN672EREmbry-Riddle Aeronautical University Inc · Prescott, AZN672MALewis University · Romeoville, ILN672SPThomas Bahamas Airways LLC · Port Orange, FLN673DWSunrise Aviation Inc · Ormond Beach, FLN673EREmbry Riddle Aeronautical University Inc · Prescott, AZN673JHAb Prop Plane II LLC · Metairie, LAN673MALewis University · Romeoville, ILN673SP673sp LLC · Blaine, MNN6744WSouthwest Flying Club · The Woodlands, TXN6745PPinnacle Aviation Services Inc · Encinitas, CAN674CPCivil Air Patrol · Maxwell Afb, ALN674DWSunrise Aviation Inc · Ormond Beach, FLN674EREmbry-Riddle Aeronautical University Inc · Prescott, AZN674MALewis University · Romeoville, ILN674TCUS Department Of Homeland Security · Washington, DCN675DBFred Paul · Tampa, FLN675DFTextron Aviation Inc · Wichita, KSN675EREmbry Riddle Aeronautical University Inc · Prescott, AZN6768RTaylor Bradley K · Muskego, WIN676CBElizabeth City State University · Elizabeth City, NCN676CPCivil Air Patrol · Maxwell Afb, ALN676DWSunrise Aviation Inc · Ormond Beach, FLN676EREmbry-Riddle Aeronautical University Inc · Prescott, AZN677AARidgeline Assets LLC · Wilmington, DEN677DMAa-Aero Inc · Fairfield, NJN677JARaji LLC · Mclean, VAN678AAWings Over Texas Holdings LLC · Denton, TXN678BPMattson William Gordon · Pequot Lakes, MNN678NDUnd Aerospace Foundation · Grand Forks, NDN678RBBoldflight LLC · Bargersville, INN678RKJ2k Plane LLC · Liberty Twp, OHN678SPFreed Bryan S · Norfolk, VAN678WWFly Cessna LLC · Peoria, AZN679BEBlue Eagle Aviation LLC · Birmingham, AL
Back to AD 2003-24-13