AD 2017-01-07
Registered aircraft · 140
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:2017-01-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:2017-01-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:2017-01-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:2017-01-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.
N696RGPecos Bend Royalties Lllp · Midland, TXN69ECAuto Midewst Inc · Niles, ILN701PPaccar Inc · Seatac, WAN706PPaccar Inc · Seatac, WAN710PPaccar Mexico Logistics Inc · Seatac, WAN717LFOnpoint Avionics LLC · Downey, CAFirst renewal noticeN725DMRhc Logistics Corp · Fostoria, OHFirst renewal noticeN733GBuzick Air LLC · Bardstown, KYN744ARTop Air Texas LLC · Glendale, CAN763PPTop Air Texas LLC · Glendale, CAN770FGHangar LLC · Las Vegas, NVN777FCAlghazzawi Hani · Holland, OHN77METrilogy Investments Ag LLC · Las Vegas, NVN803NLN803nl LLC · Forest, VAN808CKKalitta Charters LLC · Ypsilanti, MIN816AXBrookfield Reliable LLC · Kansas City, MON819EXPreserve Air LLC · Honolulu, HIN820CKKalitta Charters LLC · Ypsilanti, MIN825WKMadunn El LLC · Wayzata, MNN830DMWord Of Life World Outreach Center Inc DBA · Murrieta, CAN83TYTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN850ENBcbg Capital LLC · Clearwater, FLN850FJPachy Music Corp · Bellflower, CAN85TNLls Aviation LLC · Nederland, TXN86TNBravo Aviation LLC · Santa Rosa Beach, FLN87KBKkb Holdings LLC · Wilmington, DEN900BBNical Aviation LLC · Austin, TXN900RARoyal Air Freight Inc · Waterford, MIN902ABAngel Brothers Enterprises Ltd · Baytown, TXN909JMRegistered aircraftN90HCFalcon Aviation LLC · Jupiter, FLN916KPKp Aviation Management LLC · Mather, CAN919WTAir Waukegan LLC · Waukegan, ILN921MLDodson International Parts Inc · Rantoul, KSN92CJSkyview LLC · Wilmington, DEN950HIsland Aviation Inc · Houston, TXN955VGTvpx Aircraft Solutions Trustee · North Salt Lake, UTN987CFPeekey Lumbus LLC · Vista, CAN98ACPf Travel LLC · Encinitas, CAN9TEAlliance Aviation Group LLC · Wilmington, DE
Back to AD 2017-01-07