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.
N703CWWasem Investments LLC · Salem, ORN703LULiberty University · Lynchburg, VAN703MMGuidry Kirby J Jr · Blanco, TXN703WMMoore Tom · Basalt, CON704AVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN704CPTextron Aviation Inc · Wichita, KSN704LULiberty University · Lynchburg, VAN704MCCrowther Construction Inc · Pleasant View, UTN704RBAirway Equipment Leasing LLC · Alpharetta, GAN705DBEbco Aviation Insurance LLC · New Bern, NCN705EFEverett Farr 182 LLC · Lewes, DEN705FGRidgeline Assets LLC · Wilmington, DEN705JAFrl Flying LLC · Seattle, WAN705JWTulare County Sheriff · Visalia, CAN705LULiberty University · Lynchburg, VAN705UChristiansen Aviation LLC · Wilmington, DEN706CPCivil Air Patrol · Maxwell Afb, ALN706LULiberty University · Lynchburg, VAN706SATextron Aviation Inc · Wichita, KSN707DAProp Flying LLC · Missoula, MTN707DPPlus2cmake9 LLC · Grant, ALN707FSky Magic Aviation Inc Trustee · Wilmington, DEN707LULiberty University · Lynchburg, VAN707PDTfs Air LLC · Loveland, CON707VTPrecision Air Vt LLC · Las Vegas, NVN708LULiberty University · Lynchburg, VAN708THH & H Contractors · Leesburg, TXFirst renewal noticeN709CPCivil Air Patrol · Maxwell Afb, ALN709DBPowerhouse Detox Inc · Otis, ORN709LULiberty University School Of Aeronautics · Lynchburg, VAN70JAN70ja LLC · Stuart, FLN70SUOhio State University · Columbus, OHN710BBGomez Juan Pablo · Mcallen, TXN710BFConway Aviation LLC · Stewartville, MNN710CPCivil Air Patrol · Maxwell Afb, ALN710GZB & B Readi-Mix LLC · Ruidoso Downs, NMN710JSLeyden Aviation LLC · Dover, DEN710KVG B Aerial Applications Inc · Slaton, TXN710LULiberty University School Of Aeronautics · Lynchburg, VAN710RRMulcahy Michael T · Perris, CAN710SATextron Aviation Inc · Wichita, KSN710SPElite Approach LLC · Chesterfield, MON7111WBetter Living Aviation Inc · Wilmington, DEN711JSSterling Flight Training · Jacksonville, FLN711KFJ-Com Aviation LLC · Richland, MSN712AMMaggie Aviation LLC · Phoenix, AZN712EREmbry-Riddle Aeronautical University Inc · Prescott, AZN712LULiberty University School Of Aeronautics · Lynchburg, VAN712MSNational Aircraft Leasing · Greenville, DEN712NVEpic Aviation Enterprises LLC · Austin, TX
Back to AD 2003-24-13