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.
N26149Textron Aviation Inc · Wichita, KSN26150Textron Aviation Inc · Wichita, KSN26153Textron Aviation Inc · Wichita, KSN261AFState Of Louisiana · Baton Rouge, LAN261CACivil Air Patrol · Maxwell Afb, ALN261CPCivil Air Patrol · Maxwell Afb, ALN261EPEpic Aviation Inc · Denison, TXN261JBoard Of Trustees Of Southern Illinois University · Murphysboro, ILN261SCIndia Aviation LLC · Oregon City, ORN2621ZWifa (Washington International Flight Academy) LLC · Gaithersburg, MDN2625CL&W Leasing LLC · Murfreesboro, TNN26264Edb Air Inc · Wilsonville, ORN2626ZJf Aviation LLC · Minot, NDN262AFState Of Louisiana · Baton Rouge, LAN262CLGiga Energy Inc · Buna, TXN262CPCivil Air Patrol · Maxwell Afb, ALN262MTBurns Mark R · Streetsboro, OHN262SHTextron Aviation Inc · Wichita, KSN2630UShaka Skies LLC · Kihei, HIN2632YAtp Aircraft 4 LLC · Wilmington, DEN2634EAzul Services LLC · Bozeman, MTN26379Wings Over Texas Holdings LLC · Denton, TXN2638ULindsey Aviation Services · Haslet, TXN263EPEpic Aviation Inc · Denison, TXN263MECommercial Aerial Images Inc · Costa Mesa, CAN263RCRichland County Sheriffs Department · Columbia, SCN263SFAb Prop Plane I LLC · Metairie, LAN26481Accessible Aviation Inc · Tupelo, MSN26499Advanced Aviation Group LLC · Frederick, MDN2649JN2649j LLC · Palm City, FLN264EPEpic Aviation Inc · Denison, TXN264ME618 Aviation LLC · Kosse, TXN264SFAb Prop Plane I LLC · Metairie, LAN26502Bugsmasher Aviation LLC · Benton, KSN26504Vista Aviation Inc · Pacoima, CAN26509Bell Air LLC · Belleville, KSN2650VSampson Merle A · Inver Grove Height, MNN2651RAtls Aviation LLC · Stuart, FLN2656GAtp Aircraft 4 LLC · Wilmington, DEN265MESunset Leasing Inc · Sarasota, FLN265SFAb Prop Plane I LLC · Metairie, LAN26613Coomes Thomas R · Hollis, OKN26616Sea Wing LLC · Camarillo, CAN2662ARogers Construction Services Inc · Boca Raton, FLN2662BGjl Aviation LLC · Fort Worth, TXN2662FGarmin International Inc · Olathe, KSN2662ZBidcal Inc · Chico, CAN26630Iasco Flight Training Inc · Redding, CAN2663XAvolant Aviation LLC · Mooresville, NCN2664UHill Flying Club Inc · St George, UT
Back to AD 2003-24-13