Skip to content

Registered aircraft · 4,469

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

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-20-04-R2') 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-20-04-R2') ORDER BY n_number

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-20-04-R2')
    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-20-04-R2')
  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-20-04-R2')
  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-20-04-R2')
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.

N145MTilley Steven E · Biddeford, MEBuilt 1977 · S/N D10061 N14661Badenhope John R · Greeneville, TNS/N D-2978 N1477GDobson John F · Union, WABuilt 1962 · S/N D-6980 N147UMartin Delano R · Spring, TXS/N D-8533 N1485GHarris John F III · Louisburg, NCBuilt 1962 · S/N D-6933 N148PRJaspar Dorsey E · Bakersfield, CABuilt 1967 · S/N D-8580 N148UUpmeyer Matthew D · Richland, WABuilt 1967 · S/N D-8437 N1497GDiaz Jose R · Bakersfield, CABuilt 1962 · S/N D-6936 N149BDLewellyn Jim · Bloomsburg, PABuilt 1976 · S/N D-9924 N149GMetro Flyers Ltd · N Richland Hills, TXBuilt 1966 · S/N D-8100 N149RBest Erectors Inc · Wilmington, DEBuilt 1978 · S/N D-10161 N14CMGallagher Michael S · Los Alamitos, CABuilt 1971 · S/N D-9298 N14DFCook Charles M · Jay, FLBuilt 1957 · S/N D-5336 N14FMDurbin Gregory M · Dallas, TXS/N D-7802 N1500FGerhold Jeremy · Rosharon, TXS/N D-8552 N1500SCianchette R Scott · Hermon, MEBuilt 1961 · S/N D-6897 N1500VTessem Rolfe S · Great Barrington, MABuilt 1970 · S/N D-9160 N1501STaylor Counsel LLC · Hoschton, GABuilt 1962 · S/N D-6898 N1501ZDaytona Aircraft Services Inc · Daytona Beach, FLBuilt 1961 · S/N D-6824 N1502SMakiva Sasha · Sonoma, CAS/N D-6899 N1502ZSmith Chad M · Danville, CABuilt 1961 · S/N D-6823 N1503ZMain Attraction LLC · Sioux Falls, SDBuilt 1961 · S/N D-6825 N1505SBluboco LLC · Northville, MIBuilt 1962 · S/N D-7037 N1507SArteta David A · Wake Forest, NCBuilt 1962 · S/N D-6935 N150UUKoshar Steven R · Coloma, MIBuilt 1961 · S/N D-6630 N150WRWhiskey Romeo LLC · Timnath, COBuilt 1969 · S/N D-8911 N1510SClark Lahn F · Pasco, WABuilt 1962 · S/N D-6940 N1512SIrwin Dennis R · San Diego, CABuilt 1962 · S/N D-6941 N1512WBryant John Mark · Knoxville, TNBuilt 1972 · S/N D-9332 N1514ZDierold Robert S · Carrollton, TXBuilt 1961 · S/N D-6832 N1515ZYanks Air Museum · Baldwin Park, CABuilt 1961 · S/N D-6831 N1516ZTulin Gary N · Sedona, AZS/N D-6836 N151VTMitchell Matthew J · Penn Yan, NYBuilt 1951 · S/N D-2714 N1520VBerka George · Wilmington, DES/N D-8159 N1525SFreund Edmund A · Lodi, CAS/N D-6967 N1526SMears Bradley J · Burlington, NCBuilt 1962 · S/N D-6969 N1527WRegistered aircraftBuilt 1972 · S/N D-9335 N1528SWilson Brent S Trustee · Dyer, NVBuilt 1962 · S/N D-6966 N152BBurgess David H · Plympton, MABuilt 1956 · S/N D-4449 N152JPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1966 · S/N D8322 N152TConrad Clayton M · San Jose, CABuilt 1962 · S/N D-6956 N1530SThrailkill Robert W · Stockton, CABuilt 1962 · S/N D-6973 N1530WMather Aviation LLC · Rancho Cordova, CABuilt 1972 · S/N D-9338 N1532ZFlying Y Farms LLC · Klamath Falls, ORBuilt 1962 · S/N D-6855 N1535SGerard Aircraft Inc · Johnson, KSBuilt 1962 · S/N D-6982 N1535ZGsp Aviation LLC · Wichita, KSBuilt 1961 · S/N D-6859 N1538SDeneve Allen J · Herndon, VABuilt 1962 · S/N D-6985 N1539ZGelber Lisa G Trustee · Tujunga, CABuilt 1961 · S/N D-6866 N1544SSharrits Jeffrey J · Carson City, NVBuilt 1962 · S/N D-6925 N1546SBoese Bruce A · Oakdale, CABuilt 1962 · S/N D-6988

Back to AD 94-20-04 R2