AD 94-05-05 R1
Registered aircraft · 26,231
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:94-05-05-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
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:94-05-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1') 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.
N22788Jensen Rosemary · Quartz Hill, CAN2278NTucker Christian T · Butler, MON22792Belmar Aviation Inc · Lexington, KYN2279HCook Michael E · Collinsville, ILN2279JN2279j LLC · Burr Oak, MIN2279NBunnell Dale L · Chesterfield, MON2279VBenedict Larry D · Dexter, NMN227LLJ.R. Aero Ltd · Eldridge, IAN227MSkyway Partners · Woodside, CAN22802Ference Jeffrey J · Chandler, AZN2280VSwinney Stephen A · Blue Springs, MON22814Kruger Warren S · Kendall, NYN2281KWest Jack T · Lamar, CON2281VCarter Nicholas J · Milton, VTN2281XEngelhart Mitchell Skiff · Roswell, GAN22821Stewart Dan R · Cashmere, WAN22826Cottrell Mark C · Leitchfield, KYN22828Shiroma Owen L · Stockton, CAN22829Vandervoort William L · Hector, MNN2282DStandhart Gary S · Wickenburg, AZN2282JReiner William · Anchorage, AKN2282KGivens Benjamin T · Ruffin, SCN2282NWelborn Mark G · Boonville, NCN22830Delancey Eddie J · Elizabeth, WVN22834Smith Earl K · Port Byron, NYN22836Smith David R · Lebanon, TNN22837Bielefeldt Brandon · Mondovi, WIN22839Morris Bernard J · Davenport, FLN2283AAnderson Thomas W · Eastsound, WAN2283JHill Douglas G · Winnebago, MNN2283ZBrown Christopher J · Arlington, WAN22846White Daniel M · Agua Dulce, CAN22847Blue Skies Aviation LLC · Alexandria, VAN2284EHarris Jeremy B · Sandy, ORN2284KLind Ronald C · Rainier, WAN2284NFinn Michael R · Maple Grove, MNN2285DJet Cane Corp · Roseville, CAN2285VFitzgerald Thomas T Jr · Park Ridge, ILN22863Roberson Henry B · Chico, CAN22865Turner Tina L · Ford, WAN22867Jacobs Lydia A · North Pole, AKN22876Rhoads Eric Scott · Costa Mesa, CAN22879Jones Dennis P · Nacogdoches, TXN2287KZaayer David R · Hillsboro, ORN2287UMuse Robert C · Vienna, VAN22882Vasiliou Adamos C · Burtonsville, MDN22886Sky High Adventures LLC · Wilmington, DEN2288NDoose Charles L · Clarendon Hills, ILN22892Miller Frank L · Ninilchik, AKN22893Hoffer Patrick N · Orr, MN
Back to AD 94-05-05 R1