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.
N337WRAer Sales Lp · Carrollton, TXN338SWN338sw LLC · Midland, TXN339AVKmwflight LLC · Wilmington, DEN33APGolden Triangle Aviation LLC · Beaumont, TXN33BCSworks Aviation LLC · Chicago, ILN33RCBank Of Utah Trustee · Salt Lake City, UTN341CWCaelum Air LLC · Houston, TXN343SCMtj Aviation LLC · Mooresville, NCN343WTPhantom Phlyers LLC · Pearland, TXN345TRJog068 Inc · Lewes, DEN348AJE E & K C LLC · New Orleans, LAN351ASRoyal Air Freight Inc · Waterford, MIN351PJPremier Jets Inc · Hillsboro, ORFirst renewal noticeN351TXDodson International Parts Inc · Rantoul, KSN352CKKalitta Charters LLC · Ypsilanti, MIN352EFDodson International Parts Inc · Rantoul, KSN353CKKalitta Charters LLC · Ypsilanti, MIN353JABasler Turbo Conversions LLC · Oshkosh, WIN354LQBrunner Aerospace LLC · Georgetown, TXN355CKKalitta Charters LLC · Ypsilanti, MIN355FAE D Santos & & Associates LLC Trustee · Wilmington, DEN355UALopez Fabio A · Denver, NCN356EJAlliance Aviation Group LLC · Wilmington, DEN356MANazareth Bay Holdings LLC · Palm Beach Gardens, FLN357CKKalitta Charters LLC · Ypsilanti, MIN358CKAirnet II LLC · Columbus, OHN359BCNesvally Aviation LLC · Houston, TXN35AEAmerican Fidelity Corp Trustee · Dover, DEN35LJDelta Bravo LLC · Taylorville, ILN35WLKalitta Charters LLC · Ypsilanti, MIN361CAN361ca LLC · Wilmington, DEN361KBpcp Falcon N361k LLC · Wilmington, DEN361LABest Friends Air LLC · Kerrville, TXN361PJPremier Jets Inc · Hillsboro, ORN362PJPremier Jets Inc · Hillsboro, ORFirst renewal noticeN362TWInjury Care Center LLC · Alpharetta, GAN365BLOverthrust Transport LLC · Denver, CON365MRDream Aviation LLC · Lawrence, KSN369UBAlliance Air Parts Acquisitions Corp · Oklahoma City, OKN36BLGo Fast Aviation LLC · El Cajon, CAN370TPPhmi Aviation LLC · Lewes, DEN3712CF900ex LLC · Minneapolis, MNN373DGAttorney Aviation LLC · Dallas, TXN375RC2022 Olivia Av LLC · Austin, TXN376BLSkyview LLC · Wilmington, DEN376DBae Systems Tss Inc · Mojave, CAN377CHHalcon Equipment Leasing LLC · Midlothian, TXN378MGDodson International Parts Inc · Rantoul, KSN37BMLas Express Aviation LLC · Las Vegas, NVN37KJBank Of Utah Owner Trustee · Salt Lake City, UT
Back to AD 2012-17-05