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.
N3433NCannon Walter B Trustee · Palo Alto, CAN3434CAnderson Casey R · Needville, TXN3434DWood Don Carlos III · Wilder, IDN3435CHarter Scott W · Estero, FLN3435JRegistration Pending · Florence, AZRegistration pendingN34362Sottile Joseph S Jr Trustee · Chandler, AZN34364Krengel Lawrence · Marengo, ILN3436DWalker Cindy R · Fairbanks, AKN34374Kundig Daniel J · Pittsboro, NCN34376Gillman Robert H · Hamburg, NYN34379Gores Thomas · Franklin, WIN3437CYaiser James F · Saint Charles, MON3437DJohnson Christopher · Danville, INN3437HAbrams Linda T · San Pedro, CAN3439CTroutman Charles W · Lincoln City, ORN3439DFord Corbin J · Bethel, AKN3439KMagnuson Neil P · Fairbanks, AKN343JHRainier Flight Service LLC · Renton, WAN343SDColeman Stephen A · Wakefield, RIN343SSShippee William S · Lake City, FLN343YAirwrench Inc · Rockton, ILN34401Puddle Jumpers Flying Club Inc · Lake Ann, MIN3440DSimpson Don DBA · Bryan, TXN3440JNoguess Michele R · Deming, NMN3442CClaire Aviation Inc · Wilmington, DEN3442DLowery Chad Lewis · Palmer, AKN3443CSale Reported · Mesa, AZSale reportedN3443DMiller Charles T · Bynum, TXN3443HPereira Ronaldo · Bridgewater, MAN3444CRichards Chad M · North Pole, AKN3444DBaker Adam J · Eaton Rapids, MIN3444KWeckman Jim L · Big Stone City, SDN3446KDensburen Farms Inc · Brawley, CAN3448CKelley Joseph T · Ocala, FLN3449DWise William Mike · Wichita, KSN344CPBlain Robert · West Richland, WAN344ENocera Frank J · Winder, GAN3450CRegistered aircraftN3451CLibby Cameron R · Spokane Valley, WAN3452HDuddy Donald Patrick · White City, ORN3453CTextron Aviation Employees Flying Club Inc · Wichita, KSN3453JBmsf Co LLC · Copalis Beach, WAN3453VJones Donald T Jr · Barrigada, GUN3454DWaterman Ty G · Defuniak Springs, FLN3454HBost Kenneth A · Rockwell, NCN3454JIslanders Flying Club · Charleston, WVN3454VZimmer Bernard A · Waxhaw, NCN3455CFinamore David R · Louisville, CON3456DLewis Terry J · Fairlee, VTN3456EHartley Leslie C · Uniontown, WA
Back to AD 94-05-05 R1