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.
N2087VTundra Aviation Inc · Casselton, NDN2087YEllsworth Matthew R · Fairbanks, AKN2087ZFischer Gary H · Savannah, GAN2088NWeeks Thomas R · San Diego, CAN2088YHowell Rebecca Elizabeth · Elgin, TXN2089BHales Janell W · Richland, WAN2089VCooley Dennis A DBA · Wasilla, AKN2089YSooter Craig A · Sedgwick, KSN208APNelson Kyle P · Union, WAN208JRButler Steve L · Sioux City, IAN208KCAcevedo Adriel · San Antonio, TXN208MBWebb Warren C · Modesto, CAN208TBBarker Terry G · Purvis, MSN208WCPlane Fun Inc Tr Trustee · Snellville, GAN2090ZRegistered aircraftRegistration pendingN2091YCut And Snip Flyers LLC · South Weber, UTN2092NSkywagons.Com LLC · Placerville, CAN2092VDavis Bryan C · Winfield, KSN2092YNiver Michael A · Plymouth, WIN2093NFevig Gordon O · Ulen, MNN2093VMellott Cole E · Central City, KYN2093YSale Reported · Agar, SDSale reportedN2094HBoulet Robert B · Atlanta, GAN2094NO'Neill Mark B · Pinckney, MIN2094YHill Karl A · Visalia, CAN2094ZSpak Andrew T · Thousand Oaks, CAN2095ALawrence David D · Roanoke, VAN2095YJurca John · Punta Gorda, FLN2095ZLoose Keith · Saint Helens, ORN2096NRegistered aircraftN2096VTetterton Greyson L · Pantego, NCN2096ZHammons Clayton W · Salome, AZN2097VOverton Robert R · Gun Barrel City, TXN2097YWulff Jonathan P · Eaton Rapids, MIN2097ZSchieferecke Jeanine · Topeka, KSN2098YLevel Altitude LLC · Seward, NEN20997Aerowood Aviation LLC · Monroe, NCN209ALawson Dustin M · Three Rivers, MIN209LJCat Agri Aviation Inc · Walnut Ridge, ARN209TOnele Dennis E · Central City, NEN20BEParker Don J · Sheridan, WYN20EMartin James P · Sioux City, IAN20HVJames Gary S · Weatherford, TXN20UPennair Inc · Albany, ORN20WDKapitan Dale S · Sauk City, WIN2100NCrane Douglas Gordon · Coquille, ORN2102NWilliams Reddoch E · Fort Walton Beach, FLN2103KKlatt Mathew · Waupaca, WIN2103VPenz Racing Co · Braselton, GAN2104MDisrud Roger G · Olathe, KS
Back to AD 94-05-05 R1