AD 92-07-05
Registered aircraft · 945
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:92-07-05')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:92-07-05')
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:92-07-05') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:92-07-05') 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.
N121JPChoice Farms LLC · Wilmington, DEN122KMerlin Labs Inc · Boston, MAN123FWBhmp King Air LLC · Fort Worth, TXN123MHBryan-Kennedy LLC · Tulsa, OKN125NJAircraft Partner Holdings Inc Trustee · Fallbrook, CAN126MMFreeman Holdings Of West Texas LLC · Medford, ORN126WAJpg & Aog LLC · Concord, NCN127MUSouthern Aircraft Consultancy Inc Trustee · Casper, WYN127TXItb Solutions LLC · Palm City, FLN127ZWAerolease LLC · Fargo, NDN129LABluebird 2000 LLC · Wilmington, DEN129TNGuardian Flight LLC · Lewisville, TXN12AXEsc-100 Executive Consulting Services LLC · Pharr, TXN12GJBuilding Ideas Inc · Los Gatos, CAN12LACentral Virginia Aviation Inc · Petersburg, VAN130GPUas Transervices Inc · Boca Raton, FLN131BLLta Group Holdings LLC · Amarillo, TXN131GPUas Transervices Inc · Boca Raton, FLN132HSCentral Virginia Aviation Inc · Petersburg, VAN135AAKentucky King Air LLC · Hazard, KYN136PAX-Press Charter Service Inc · Longview, TXN137BABemidji Aviation Services Inc · Bemidji, MNN139JBQuay Ventures LLC · Alto, TXN139SCNew Ulm C90 LLC · Marshall, MNN13GZGuardian Flight LLC · South Jordan, UTN140HAxis Transportation Services LLC · Sacramento, CAN140PAJump Plane Of Pittsburgh LLC · Mercer, PAN143FWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN145AFDale Aviation Inc · Rapid City, SDN147LJGuardian Flight LLC · Lewisville, TXN14NMDriscoll Health Care Services · Corpus Christi, TXN14SBMountain Air Aviation LLC · Jonesville, VAN14VDouble D International LLC · Miami, FLN150GWRocinante Air LLC · Cincinnati, OHN150TWCentral Virginia Aviation Inc · North Dinwiddie, VAN150VECarnes 150ve LLC · Wichita Falls, TXN152WWNardi Greg · Missoula, MTN1544VGuardian Flight LLC · Lewisville, TXN1552DDodson International Parts Inc · Rantoul, KSN1552GEast Atlantic Aviation LLC · Edenton, NCN1553GMccloy Mark · Tatum, NMN155LSRainair Avionics Services LLC · Albertville, ALN156GAlliance Air Parts Acquisitions Corp · Oklahoma City, OKN157MHMile Hi Skydivers Inc · Longmont, CON15CTSkydive Grand Haven LLC · Grand Haven, MIN162STState Of Michigan · Lansing, MIN164WSBank Of Utah Trustee · Salt Lake City, UTN167BBCentral Virginia Aviation Inc · Petersburg, VAN1685SBella Vista Transportation & Rentals LLC · Dunnellon, FLN169DRLegacy Aviation LLC · Tea, SD
Back to AD 92-07-05