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.
N5181BSoutheastern Oklahoma State University · Durant, OKN5181EMustang Sally Aviation LLC · Camden, SCN5181VWarden Stephen M · Sugar Land, TXN51824US Department Of Homeland Security · Washington, DCN51827B D Aviation LLC · Sauget, ILN5182AIasco Flight Training Inc · Redding, CAN5182RHalf Wagon Innovations LLC · Cresson, TXN51847Rippe Ryan · Fairbury, NEN51849O'Ryan Air LLC · Wichita, KSN5184GSicking Ryan · Gainesville, TXN5184PBarr Air Patrol LLC · Mesquite, TXN5185UMoyer Aviation Inc · Tobyhanna, PAN5185YPiedmont Flight Inc · Winston Salem, NCN5187AHada Benjamin · Andrews, TXN5188BRegier Tom · Dinuba, CAN5188LMascari Nicholas M · Mundelein, ILN5188TCohen Edward R · Loomis, CAN5189DRiverside Pipe LLC · Farmington, NMN518CRM & A Aircraft LLC · Wilmington, DEN518SPGreater Flint Pilots Associations Inc · Flushing, MIN5190AArias Antonio · Lakeway, TXN5190JAoa Kissimmee Inc · Kissimmee, FLN5190RIasco Flight Training Inc · Redding, CAN5191FArapahoe Aero Aircraft Sales LLC · Englewood, CON5193MTar Pit Investments LLC · Austin, TXN5194NAndros Aviation LLC · Santa Margarita, CAN5195UChi Aerospace Inc · Portsmouth, NHN5195YUrbana Aircraft LLC · Urbana, MDN51964Shorebird LLC · West Chester, PAN5196GOlasz Jonathan S · West Barnstable, MAN5196KMiller Andrew Howard · Granbury, TXN5196PEsbenshade Wilmer R · New Holland, PAN5197GDirect-To LLC · Cedar Park, TXN5197TUw Flying Club Inc · Sun Prairie, WIN5198GConaway David L · Las Vegas, NVN5198JMichigan Dept Of Natural Resources · Roscommon, MIN5198QValiair Lc Trustee · Casper, WYN5198TBlack Dog Aviation LLC · Troy, MIN5199BFly172s LLC · Peoria, AZN5199JG&M Aircraft Inc · Wheat Ridge, CON519AMRegistration Pending · Manheim, PARegistration pendingN519ERStick & Rudder Club Inc · Waukegan, ILN519NDChristiansen Aviation LLC · Wilmington, DEN51CHEcho Acquisitions LLC · Dover, DEN51HFSan Mateo County Sheriff'S Office · Redwood City, CAN51UDAlf Ix LLC · Chicago, ILN5200ABarr Air Patrol LLC · Mesquite, TXN52034Arq Aviation LLC · Wilmington, NCN5204NN5204n LLC · Palm City, FLN52057Redstone Arsenal Flying Activity · Redstone Arsenal, AL
Back to AD 2003-24-13