AD 2001-01-05
Registered aircraft · 149
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:2001-01-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:2001-01-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:2001-01-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:2001-01-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.
N696RGPecos Bend Royalties Lllp · Midland, TXN6FJFlying Farmer LLC · Wilmington, DEN701PPaccar Inc · Seatac, WAN706PPaccar Inc · Seatac, WAN707CXV1vr LLC · Wilmington, DEN710PPaccar Mexico Logistics Inc · Seatac, WAN715JCFlying Farmer LLC · Wilmington, DEN717DHDarkhorse Aviation LLC · Georgetown, TXN717LFOnpoint Avionics LLC · Downey, CAFirst renewal noticeN71MSkyview LLC · Wilmington, DEN725CJClub Jet Investments LLC · Wilmington, DEN725DMRhc Logistics Corp · Fostoria, OHFirst renewal noticeN733GBuzick Air LLC · Bardstown, KYN73LRFalcon N73lr LLC · Belton, TXN744ARTop Air Texas LLC · Glendale, CAN763PPTop Air Texas LLC · Glendale, CAN77METrilogy Investments Ag LLC · Las Vegas, NVN79CJV1vr LLC · Wilmington, DEN803NLN803nl LLC · Forest, VAN816AXBrookfield Reliable LLC · Kansas City, MON819EXPreserve Air LLC · Honolulu, HIN825WKMadunn El LLC · Wayzata, MNN830DMWord Of Life World Outreach Center Inc DBA · Murrieta, CAN832WDDodson International Parts Inc · Rantoul, KSN83TYTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN84TJUsaircraft Inc · Newark, DEN850ENBcbg Capital LLC · Clearwater, FLN850FJPachy Music Corp · Bellflower, CAN858SPBrown Lawson M II · San Diego, CAN85TNLls Aviation LLC · Nederland, TXN86TNBravo Aviation LLC · Santa Rosa Beach, FLN87KBKkb Holdings LLC · Wilmington, DEN87RTPremier Lj40 Inc · Wilmington, DEN882YDDodson International Parts Inc · Rantoul, KSN8LTAviation Enterprises Inc · Marietta, GAN900BBNical Aviation LLC · Austin, TXN902ABAngel Brothers Enterprises Ltd · Baytown, TXN908TFSkyview LLC · Wilmington, DEN909JMRegistered aircraftN90HCFalcon Aviation LLC · Jupiter, FLN916KPKp Aviation Management LLC · Mather, CAN919WTAir Waukegan LLC · Waukegan, ILN92CJSkyview LLC · Wilmington, DEN950HIsland Aviation Inc · Houston, TXN955VGTvpx Aircraft Solutions Trustee · North Salt Lake, UTN957ECBank Of Utah Trustee · Salt Lake City, UTN987CFPeekey Lumbus LLC · Vista, CAN98ACPf Travel LLC · Encinitas, CAN9TEAlliance Aviation Group LLC · Wilmington, DE
Back to AD 2001-01-05