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.
N6051VBucelluni Brett · Cypress, TXN6052JBrite Angel Landing Inc · Mccall, IDN60533K2 Investment Fund LLC · Zephyr Cove, NVN6053CTaylor Travis E · Olathe, CON6056EInfinity Flight Ltd · Wilmington, DEN60587Jbb Enterprises LLC · Lewes, DEN6058PJarrett Holdings LLC · Wink, TXN6058SHamilton John · Clinton, WAN6059DLong Island Aviators LLC · Seaford, NYN6059RGlidewell Aviation Inc · Parkland, FLN6059YCrazy Mountain Legacy LLC · Missoula, MTN605ACCullen Brian L · Yuma, AZN605EREmbry-Riddle Aeronautical University Inc · Prescott, AZN605MAAir Assets LLC · Orlando, FLN605SDMedary Aviation LLC · Brookings, SDN605SGN605sg Aviation LLC · Wilmington, DEN605WMZwl Consulting LLC · San Francisco, CAN60603Christiansen Aviation LLC · Wilmington, DEN6060NNord Excavation Inc · Rigby, IDN60616Mustang Sally Aviation LLC · Camden, SCN6062GSplatman Aviation LLC · North Salt Lake, UTN6063KCanyon Construction Co · Elko, NVN6064MW E Aviation LLC · Fort Worth, TXN6064PWise Security Systems LLC · Myrtle Point, ORN6064RSvetfur Aviation LLC · Camden, SCN6065LAvolant Aviation LLC · Mooresville, NCN6065MPhoenix East Aviation LLC · Daytona Beach, FLN6065PS R Liner LLC · Canton, MAN6065RSouthern Tier Express Inc · Andover, NYN606DBBode Aviation Inc · Albuquerque, NMN606LFLunken Flight Training Center LLC · Cincinnati, OHN606NDDavidson Flight Service LLC · Gig Harbor, WAN606TCWings Over Texas Holdings LLC · Denton, TXN6071NJames Selle Aviation LLC · Bonesteel, SDN60722Reynolds Timothy · Albuquerque, NMN6072TThibault Dominic · Titusville, FLN6074FFly America Inc · Palo Alto, CAN6075MLz Max Air LLC · Atlanta, GAN6076TFauntleroy David W Trustee · Geneva, ILN6076YRemuda San Pedro LLC · San Antonio, TXN6078TSouthern Aircraft Consultancy Inc Trustee · Casper, WYN607DMAdx LLC · Saint Marys, KSN607MCGilbert Aviation Inc · Wilmington, DEN607MLIprop LLC · Palm Beach Gardens, FLN607TMN607tm LLC · Englewood, CON60809Van Bortel Aircraft Inc · Arlington, TXN608EREmbry-Riddle Aeronautical University Inc · Prescott, AZN608GLWetzel Gary Charles · Dallas, TXN608MCPeak Aviation LLC · Salida, CON608SHNational Aircraft Leasing Corp · Greenville, DE
Back to AD 2003-24-13