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.
N4240UDennis P Berky Enterprises LLC · Winder, GAN4240VLadage Terry L · Champaign, ILN42417Mace Thomas Richard · Jacksonville, FLN4241FPankhurst Terrell K · Lauderdale, MSN4241LAshland Flyers LLC · Bayfield, WIN4242CCas LLC Trustee · Ballinrobe Co MayoN4242EMorrell Samuel C · Lake City, MIN4242FChronis Marc D · Pembroke, NHN4242HWebb Greg · Sweetwater, TNN4242LHannon Douglas L · Yakima, WAN4242MPapineau John B · Atchison, KSN42432Wilson Mickey R · Skagway, AKN4243FEagle Glen Veterinary Services Inc · Corona, CAN4243LNorth Central Marketing Inc · Cranston, RIN4243UN4243u LLC · Wilmington, DEN42443Older Dan · Bellingham, WAN42445Grammer Samuel Emmett Jr · Wasilla, AKN42447Brown Jon K Administrator · Winter Haven, FLN4244ANunn Marvin T · Lovell, WYN4244ETucker Alan K · Taberg, NYN42455Idaho Aviation LLC · Rexburg, IDN4245LAero Missions Inc · Sylacauga, ALN4245NSell Scott F · Moody, TXN42468Barton Douglas A · Moorpark, CAN4246EHansen Karl G · Waxahachie, TXN4246VMesserly John A · Altus, OKN42480Clegg Stephen A · Port Orange, FLN42481Smiley Neil G · Clover, VAN4248FWilcox Ross P · Newark, DEN4248UEyles Benson G · Hampden, MEN42494Goebel William R · Rhome, TXN42497Mission Aviators LLC · Spring, TXN42498Beaver Barry G · Shelby, NCN4249EPerron Ted J · White Bear Lake, MNN4249LKraus Gary L · Holbrook, PAN4249NCessna 140 LLC · Taylor, MON424BCPikeside Flying Club Inc · Martinsburg, WVN424EFGullet Samuel H · Lafayette, LAN42500Fowler Pamela J · Zebulon, NCN42509Lake Placid Flyer LLC · Lake Placid, FLN4250LKnight Aire LLC · Simpsonville, SCN4250UBrownfield Bruce · Oak Park, CAN4250VSnyder Michael Scott · Erie, CON42523Sale Reported · Herriman, UTSale reportedN4252LStephani Timothy M · White Lake, WIN4252NEads Arthur H · Jackson, OHN4252V212 Investments Of Montana LLC · Owasso, OKN4253EPrice James A · Melba, IDN4253UConrad Chace D · Maryville, TNN4254FRed Baron LLC · Davis City, IA
Back to AD 94-05-05 R1