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.
N5225REnright Darren · Lakeville, MNN5225YGarret G Enterprises LLC DBA · Lakewood, CON52262Skymates Inc · Wilmington, DEN5226DFargo Jet Center LLC · Fargo, NDN5226KHailey Medical Staffing LLC · Hailey, IDN5226QNitsche Robert Kevin · Giddings, TXN52278Fox Kevin Richard · Murrieta, CAN5227SDcrss LLC · Marcy, NYN52285Calcasieu Parish Sheriffs Office · Lake Charles, LAN5229CInertia Engineering & Machine Works Inc · Stockton, CAN522AFState Of Louisiana · Baton Rouge, LAN522BSSnapdog Services Inc · Wilmington, DEN522CSKarpinski Arthur A · Jordan, NYN522EREmbry-Riddle Aeronautical University Inc · Prescott, AZN522MCRegistered aircraftN522NDSpartan Education LLC · Tulsa, OKN522QFFlight Training Aircraft LLC · Wilmington, DEN522RARaven Aircraft LLC · Prescott, AZN522SDSouth Dakota State University · Brookings, SDN522VSArq Aviation LLC · Wilmington, NCN5230DColeman Mark W · Longview, TXN5231CAir Cooled Flyers LLC · Austin, TXN5231MElliott Cedric · Huffman, TXN52340Textron Aviation Inc · Wichita, KSN5236UVan Bortel Aircraft Inc · Arlington, TXN5236VT And G Investments LLC · Gulfport, MSN5237YWerninghaus Karla I · Reno, NVN5238HGalatians182 LLC · Kalispell, MTN5239YDumitrache Christina Marie · Mankato, MNN523ABVector Air LLC · Erie, CON523ERBagamaspad Alan M · Reseda, CAN523NDSunrise Aviation Inc · Ormond Beach, FLN523PHNby Productions · Bristow, VAN523SMFirst Owl Creek LLC · Aspen, CON523SPArkansas State Police · Little Rock, ARN5241SHpt Aero LLC · Longboat Key, FLN5242NDonnelly Donald Dean Trustee · Tyler, TXN5242URegistered aircraftN5243TBayley Inc · Henderson, NVN52449Nyama Leo LLC · San Antonio, TXN5244QVan Bortel Aircraft Inc · Arlington, TXN524BQHfaw LLC · Augusta, GAN524CPCivil Air Patrol · Maxwell Afb, ALN524NDPhoenix East Aviation LLC · Daytona Beach, FLN52519Northwestern Michigan College · Traverse City, MIN5251ZMustang Sally Aviation LLC · Camden, SCN52522Mustang Sally Aviation LLC · Camden, SCN5252JNorthwestern Michigan College · Traverse City, MIN52531Csa Aircraft Leasing LLC · Salt Lake City, UTN52535Voroshuck Clayton T · Sunnyvale, CA
Back to AD 2003-24-13