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.
N656TCPremier Legacy Aviation LLC · Lewes, DEN65729Nevrdul LLC · Cambridge, MDN65738Mc Collom Perry C · Saint Louis, MON65745Mustang Sally Aviation LLC · Camden, SCN65790Horan Peter · North Easton, MAN65795Bank Of Utah Trustee · Salt Lake City, UTN657CPCivil Air Patrol · Maxwell Afb, ALN657EREmbry-Riddle Aeronautical University · Prescott, AZN657SPChristiansen Aviation LLC · Wilmington, DEN657TPZma LLC · North Little Rock, ARN65805Wilkerson William E · Crewe, VAN65841Just Plane Stuff Inc · Jackson, MSN65853Morando Donald W · Myrtle Beach, SCN65860Edb Air Inc · Wilsonville, ORN65862Top Flight Aviation Inc · Corona, CAN658AKWright David · Bellaire, TXN658CPArizona Air Salvage · Phoenix, AZN658EREmbry-Riddle Aeronautical University Inc · Prescott, AZN658MACantele Joseph D · Hickory Hills, ILN658PWWheels Up Aviation LLC · Cochran, GAN658XLMertz George H III · Reading, PAN65903N65903 LLC · Union Gap, WAN65904Electra Aviation LLC · Wilmington, DEN65908Sanders Thomas W · Overgaard, AZN65912Lima Alfa LLC · Whitefish, MTN65920Hellroaring Technologies Inc · Polson, MTN65926Pc Aviation LLC · Kanarraville, UTN65927Garmin International Inc · Olathe, KSN65932Techflitewest LLC · Brookville, OHN65937Berendschot Leonardus · Huntsville, TXN65956Ameriflyers Of Texas Inc · Addison, TXN65957Skybourne LLC · Stuart, VAN65971Georgalos Aircraft LLC · Eagle Point, ORN65988Arkansas Industrial Manufacturing LLC · Wilmington, DEN65991Crysler Douglas Michael · Rockford, MIN65995Phoenix Flyers Inc · Mesa, AZN659BDHeritage Aviation Management Ltd · Conroe, TXN659EREmbry-Riddle Aeronautical University Inc · Prescott, AZN659SPChristiansen Aviation LLC · Wilmington, DEN659TCYokin Around LLC · Ketchum, IDN65BLWhite Craig S · Troy, OHN65EHTextron Aviation Inc · Wichita, KSN65FDBarnstormer Leasing LLC · Murfreesboro, TNN65HFHorizon Flight Center LLC · Chesapeake, VAN65KCBarr Air Patrol LLC · Mesquite, TXN65TJHigh Wing 182t LLC · Helena, MTN66005Slp III 1 LLC · Columbia, MON66010Crane William Jr · Somerville, ALN66025Suburban Air Corp · Castro Valley, CAN66029Wpf Air LLC · Fort Myers, FL
Back to AD 2003-24-13