AD 84-10-01 R1
Registered aircraft · 20,483
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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.
N429JPHnb Aviation LLC · Forestburg, TXN429PCShanks Charles Scott · Edmonds, WAN42AVIsland Aero LLC · East Northport, NYN42BHDondelinger Consulting LLC · Brainerd, MNN42EMNbc Sales LLC · Somerville, TNN42GVBlahnik Vance Thomas Trustee · Eden Prairie, MNN42KCChatham Kenneth W · Montross, VAN42RHGet-U-There Air LLC · Poplar Grove, ILN42WDRegistration Pending · Seattle, WARegistration pendingN42WGEl Paso Industries Inc · Santa Teresa, NMN4303SCartersfly LLC · Lewes, DEN43043Environmental Safety & Health Consulting Svcs Inc · Houma, LAN4306NWesner Robert F · El Reno, OKN430DBIkard James C · Shelbyville, TNN430KUlve Scott David · Camdenton, MON430MState Of Louisiana · Baton Rouge, LAN4310NMilton William H · Amsterdam, NYN4310VRobertson Nathan M · Acworth, GAN4311NSchafhausen Mark G · Spokane, WAN4312NBarron John L · Perry, MON4318NBybee James W · West Jordan, UTN4319VBarron Jon M · Perry, MON431AFBuha Holdings LLC · Paris, TXN431MLFarr Francis A · Bozeman, MTN4321XGrady Auctions & Realty Inc · Newport, ARN4323NGrant Yeol D · Livermore, CAN4323VRhodes John D · Tarzana, CAN4324NLeighton George E · Seattle, WAN4327VFultz Andrew J · Starkville, MSN4328VLumcavok Aviation 1 Inc · Middletown, DEN4329NPulver Douglas A · Kenockee, MIN432BAAnderson Jerry J · Vacaville, CAN432DBDepcinski Travis A · Fairbanks, AKN432ELazy J Aeroplanes LLC · Beverly, WVN432MTFoundation Holdings LLC · Jonesboro, ARN432RRFirst Plane LLC · Erie, PAN432SUlman Morrison · San Carlos, CAN432TSModern Air Solutions LLC · Panama City Beach, FLN4330NMays Kevin E · West Liberty, KYN4331NThomsen Consulting Inc DBA · Monee, ILN4332VKenaga Michael L · Downers Grove, ILN4334NHardy John A · El Paso, TXN4335VMartin Edward I · Trinity Center, CAN4336NKrcma William H · Washburn, WIN4337NAlldredge Aviation · Auburn, WAN4339VColtrin Christopher S · Schaumburg, ILN433LLSkydive Coolidge Inc · Tempe, AZN433SBRico Kermot Aviation LLC · San Clemente, CAN4344NHernden Mike · Rockford, ILN4344VBarron Aviation LLC · Perry, MO
Back to AD 84-10-01 R1