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.
N415ESlakes James T · Portage, INN415EEHarvell Randy · Manteno, ILN415FBrigger Teddy D · Clarion, IAN415GWebber Gregory W · Nyssa, ORN415JC1st Resources Unltd Inc · Houston, TXN415JDKown William Bruce · Hamilton, ALN415KDNougaret Ken · Mc Alpin, FLN415LLBawtinheimer Kris · Grand Rapids, MIN415LS1st Resources Unltd Inc · Houston, TXN415SS1st Resources Unltd Inc · Houston, TXFirst renewal noticeN415TBLeuthold Mike · Concord, CAN415TRMyrick Richard L · Williamson, GAN4160Ramin Jeanette J · Houston, TXN4161FGilbertson Daniel E · Duluth, MNN4161HMintkenbaugh Russell Robert · West Chester, OHN4161LBruner Harvey L · Latexo, TXN41627Godfrey Denis B · Grand Junction, CON4162EGround Loopers Flight Club LLC · Gunnison, UTN4162FPowell Clinton J · Pleasanton, TXN4162NDavis Chuck · Santa Paula, CAN4162UGiammarino Brian L · Antrim, NHN4162VUntiet Steven R · Homer, AKN4163LLeitzman Robert A · Tucson, AZN4163NOrland William B · Santee, CAN4163UWilson Jim A · Grand Rapids, MNN4163VRoot Shane G · Dighton, KSN4164EVitale Andrew R · Middletown, NYN4164LDerwin Diversified Inc · Santa Paula, CAN4164URogers Robert P · Dubuque, IAN4164VRowe Dennis A · Vandergrift, PAN4165VHagen Curt L · Sullivan, WIN4166EMpms Inc · Munford, TNN4166LWarbelows Air Ventures · Fairbanks, AKN4166NRound Robin Aviation Inc · Benton, KSN4166VFreitas Anthony F · Canby, ORN4167FHamburg Jeffrey B · Warner Robins, GAN4167URegistered aircraftN4168Url Todd R · Houston, TXN4168FOfarrell Leo S · Lakeport, CAN4168LRoberts James E · Golconda, ILN4168VLehr F Mark · Placitas, NMN4169ULofstrom David J · Chugiak, AKN416DCWeaver Eric W · Anchorage, AKN4170BOutman William D · Half Moon Bay, CAN4170CDemientieff Oscar · Anchorage, AKN4170EHuntling Terry · Indio, CAN4170USwan Guy · West Palm Beach, FLN4171LFleeman Danny W · Manila, ARN41729Naca 130 LLC · Cameron Park, CAN4172FEdwon Ronnie L · Mesa, AZ
Back to AD 94-05-05 R1