AD 2012-17-05
Registered aircraft · 1,197
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:2012-17-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:2012-17-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:2012-17-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:2012-17-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.
N381CWN650rj LLC · Marshall, MNN383MCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN383MVN383mv LLC · Amarillo, TXN383TKThk Holdings LLC · Cincinnati, OHN384ABArkoma Air LLC · Rockwall, TXN384PBOvation Jet Parts LLC · Smyrna, DEN385RCTms Global Investments Inc · Naples, FLN387TSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN388WA2029 Aircraft Trust 2 LLC Trustee · Davie, FLFirst renewal noticeN389AWAir Gato Enterprises Inc · Clearwater, FLN389SRIgnite Enterprises LLC · Cerritos, CAN38MGBay Venture Management LLC · Atlanta, GAN38PSAlliance Air Parts Acquisitions Corp · Oklahoma City, OKNon-citizen corporation, flight hours not reportedN38TVLs Mobile LLC · Weatherford, TXN391BVcs Encore LLC · Austin, TXN393SCN169px LLC · Delaware, OHN395HEBillron LLC · Houston, TXN39FNGh Equipment LLC · Dover, DEN39GXPitch N Power Aviation Inc · Jupiter, FLN400CZDodson International Parts Inc · Rantoul, KSFirst renewal noticeN400GPIcmc Idaho LLC · Salinas, CAN400GSGreen Savoree Transportation LLC · Carmel, INN401JWWatts John I · Murchison, TXN402HMAer Sales Lp · Carrollton, TXN404BYMalagamar LLC · Fort Myers, FLN404FZBogey Bird II Inc · Jeffersonville, INN406CUSs Leasing II LLC · Eau Claire, WIN406TMAlcyone Trust Corp Trustee · Wichita, KSN40AGNew Chat Air LLC · Chattanooga, TNN40BGAlliance Air Parts Acquisitions Corp · Oklahoma City, OKNon-citizen corporation, flight hours not reportedN40GPBank Of Utah Trustee · Salt Lake City, UTN411CDRegistered aircraftN411SCRegistered aircraftN412DAVida Trade And Management Group LLC · Charlotte, NCN412JADodson International Parts Inc · Rantoul, KSN412SWThunderforce Investments LLC · Washington, DCN413HSAerotrust Services Corp Trustee · Wilmington, DEN413MHFastair Inc · Columbia Station, OHN414PEAerotrust Services Corp Trustee · Wilmington, DEN417TMCpj2 LLC · Garden City, NYN422CSBusiness Jet Managers Inc · Canton, MIN423SGSworks Aviation LLC · Chicago, ILN424JRGravitas Aviation LLC · Dallas, TXN424TGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN426MJArbuckle II LLC · Missoula, MTN428DRMaverick Air II LLC · Deer Park, WAN429FCLopez Fabio · Denver, NCN42GEWatts John · Murchison, TXN42JJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN431CKKalitta Charters LLC · Ypsilanti, MI
Back to AD 2012-17-05