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.
N527DKEci Staffing Solutions Inc · Stamford, CTN527DPNavair LLC · Mount Vernon, OHN527DSSkyhawk Leasing LLC · Greenfield, INN527NDPhoenix East Aviation LLC · Daytona Beach, FLN527ZMTextron Aviation Inc · Wichita, KSN5280DHdw Florida Helicopters Inc · Pompano Beach, FLN5280RSpringbrook Leasing LLC · Daytona Beach, FLN5283CRanchaero LLC · Houston, TXN5284SFly America Inc · Stanford, CAN52858Channel Islands Aviation Inc · Camarillo, CAN5286CUnited Flying Club Inc · Belmont, CAN5288TG & S Air Adventures LLC · Jersey City, NJN5289HClarke Simon P · Seattle, WAN528CPCivil Air Patrol · Maxwell Afb, ALN528ERMary Air LLC · White Rock, NMN528HWyoming Management LLC · Sheridan, WYN528KCBukhart Don · Blakely Island, WAN528LDCar Two Charlie LLC · Lewes, DEN528LEZeus Aviation LLC · Carlisle, OHN528LSYoung Robert A · Mount Desert, MEN528MJAircraft Owners & Pilots Association · Frederick, MDN528NDAerosim Academy Inc · Sanford, FLN528PVMelin Mark Alan · Newport, NCN528SCMaxxum Financial Group Inc · Destrehan, LAN528SVFox Leasing Group LLC · Hollywood, FLN528WBAdvantage U S A A Inc · Spring Branch, TXN5290ESpacely Space Sprockets LLC · Aurora, ORN5290HLevy James L · Clifton Park, NYN5290VSpartan Education LLC · Tulsa, OKN5291ALewis Aeronautical LLC · San Antonio, TXN5291WMaxxum Financial Group Inc · Destrehan, LAN5293PRogue Aero LLC · Grants Pass, ORN5294WSonneborn Arthur Aaron · East Leroy, MIN5296DZack Gary J · Sunderland, VTN5296ZSouthern Sky LLC · Henderson, NVN5297EAtd Pilot Training LLC · Kansas City, MON5297GChristiansen Aviation LLC · Wilmington, DEN5298NJ3m Airops LLC · Daytona Beach, FLN5298SSix Ten Ventures LLC · Grand Prairie, TXN529ERPs N529er LLC · Green Bay, WIN529NDPhoenix East Aviation LLC · Daytona Beach, FLN529PTLt Express LLC · Carson City, NVN529SDReal Property Strategies LLC · Los Gatos, CAN52ACBloxham Tod · Tacoma, WAN52HAAssociated Packaging Inc · Gallatin, TNN52LULetourneau University · Longview, TXN52TMJorgensen Aviation Inc · Richfield, UTN53020Iasco Flight Training Inc · Redding, CAN5302XFnb Flying Club LLC · Gallatin, TNN53039Laurel Highlands Aeronautical Academy · Latrobe, PA
Back to AD 2003-24-13