AD 2003-07-07
Registered aircraft · 373
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-07-07')
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-07-07')
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-07-07') 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-07-07') 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.
N343SCMtj Aviation LLC · Mooresville, NCN348AJE E & K C LLC · New Orleans, LAN353JABasler Turbo Conversions LLC · Oshkosh, WIN355FAE D Santos & & Associates LLC Trustee · Wilmington, DEN356EJAlliance Aviation Group LLC · Wilmington, DEN356MANazareth Bay Holdings LLC · Palm Beach Gardens, FLN361CAN361ca LLC · Wilmington, DEN361LABest Friends Air LLC · Kerrville, TXN369UBAlliance Air Parts Acquisitions Corp · Oklahoma City, OKN375PFConch Air LLC · Green Bay, WIN375RC2022 Olivia Av LLC · Austin, TXN383MVN383mv LLC · Amarillo, TXN383TKThk Holdings LLC · Cincinnati, OHN384ABArkoma Air LLC · Rockwall, TXN389SRIgnite Enterprises LLC · Cerritos, CAN391BVcs Encore LLC · Austin, TXN406TMAlcyone Trust Corp Trustee · Wichita, KSN411SCRegistered aircraftN412DAVida Trade And Management Group LLC · Charlotte, NCN412JADodson International Parts Inc · Rantoul, KSN413HSAerotrust Services Corp Trustee · Wilmington, DEN414PEAerotrust Services Corp Trustee · Wilmington, DEN417TMCpj2 LLC · Garden City, NYN418CASkybus Inc · North Miami Beach, FLN422CSBusiness Jet Managers Inc · Canton, MIN423SGSworks Aviation LLC · Chicago, ILN42JJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN432SMWorldwide Option LLC · Lewes, DEN4343FFrenkel Tardis Development Corp LLC · Dallas, TXN43JRGlobal Avionics LLC · Downey, CAN43MMAircraft Holding Solutions LLC · Newark, DEN43TPAircraft Holding Solutions LLC Trustee · Newark, DEN440WPBbft Aero Holdings LLC · Columbus, OHN442MSWd Aviation Group Inc · Atlanta, GAN444JFBod Aviation LLC · Los Angeles, CAN44MBTria Entertainment LLC · Wisconsin Dells, WIN44UNHawker 258359 LLC · Dover, DEN457JAviation Leasing Group Inc · Wilmington, DEN45GDPacific Rim Management LLC · Middletown, DEN45KNHawker800xp LLC · Dorado, PRN469RJDodson International Parts Inc · Rantoul, KSN474CFCarrousel Aviation LLC · Monroe, WIN475HMFalcon Double D 163 LLC · Fort Lauderdale, FLN475RSRomeo Sierra LLC · Morgantown, WVN47HAHoosier Jets LLC · Sellersburg, INN47HWCelebration Tv America Inc · Houston, TXN488AMByte Me Transportation Inc · Fort Pierce, FLN489BMEd Santos & Associates LLC Trustee · Wilmington, DEN492DYLerma Aviation LLC · Dallas, TXN499PANe Charters LLC · South Jordan, UT
Back to AD 2003-07-07