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.

N8844MNewberry Travis · Niota, TNBuilt 1964 · S/N D-7357 N8848MFly Shetland LLC · Lubbock, TXS/N D-7360 N884TPerryton Motor Co Inc · Perryton, TXBuilt 1965 · S/N D-7807 N8851MBal-Kar Holdings Inc · Punta Gorda, FLBuilt 1964 · S/N D-7362 N8852MAndys Auto Sales LLC · Caroline, WIBuilt 1964 · S/N D-7367 N8853MBeaver Creek Aviation LLC · Clinton, OKBuilt 1964 · S/N D-7368 N8888AGrundmann Daniel J · South Jordan, UTBuilt 1952 · S/N D-3211 N888DBEastern Stearman Inc Trustee · Leesburg, VAS/N D10076 N888DWGoodman James D Trustee · Pomona, CABuilt 1962 · S/N D-7049 N888KWHink Ronald · Memphis, TXBuilt 1966 · S/N D-8219 N888NEFarmex Land Mgmt Inc · Sanger, CABuilt 1981 · S/N D-10367 N888RMMikmot LLC · Elk Point, SDS/N D-7270 N888SK5 Aviation LLC · Las Vegas, NVBuilt 1976 · S/N D-9937 N888SHLopez Benjamin · Batavia, OHBuilt 1969 · S/N D-9066 N889JSMoran Consulting Corp · Long Beach, CABuilt 1974 · S/N D-9579 N889RQualitair LLC Trustee · MichelstadtBuilt 1960 · S/N D-6366 N88BVCarr Phillip E · Cave Creek, AZBuilt 1977 · S/N D10060 N88JWHawk Aviation LLC · Burlington, WIBuilt 1955 · S/N D-4409 N88RRegistration Pending · Wilmington, DERegistration pendingBuilt 1973 · S/N D-9475 N8902ULusby II Dale · Garden Valley, CABuilt 1965 · S/N D-7902 N8903UMartin William C · Middleville, MIBuilt 1965 · S/N D-7903 N8906MSaindon Michael R · Cypress, TXBuilt 1963 · S/N D-7304 N8906UKelley William · Springtown, TXS/N D-7906 N8907USprague Allen T · Warrenton, ORBuilt 1965 · S/N D-7907 N8908MKeyes Richard A · Port Saint Lucie, FLBuilt 1963 · S/N D-7305 N8908UFly Buys Too LLC · Wilmington, DEBuilt 1965 · S/N D-7908 N8909ATowery Daniel T III · Dover, DES/N D-2683 N890RChitwood Thomas · Hartwell, GABuilt 1960 · S/N D-6365 N890WBelcher Timothy A · Liberty, KSBuilt 1964 · S/N D-7563 N8917MAero Flite Del Inc · Felton, DEBuilt 1964 · S/N D-7322 N8917UBashaw Trenton C · Newport Beach, CABuilt 1965 · S/N D-7910 N891JHBecker Lawrence D · Anacortes, WABuilt 1955 · S/N D-4101 N8921ULucy Donald E III · Newbury Park, CABuilt 1965 · S/N D-7911 N8922UN8922u LLC · Twin Falls, IDS/N D-7913 N8923UCarolina Insulation & Foam Inc · Asheboro, NCBuilt 1965 · S/N D-7917 N8924MTre Aviation Corp · Wilmington, DEBuilt 1964 · S/N D-7337 N8930ACusick Christopher J · La Jolla, CABuilt 1951 · S/N D-2684 N8932US35 Aviation LLC · Lakeland, FLBuilt 1965 · S/N D-7921 N8939ABoyd Craig S · Richardson, TXBuilt 1951 · S/N D-2693 N8939USiegfried Robert W II · Downers Grove, ILBuilt 1965 · S/N D-7924 N8942UConner Ernest A III · Dallas, TXBuilt 1965 · S/N D-7933 N8944APetersen Amos I · Iowa City, IAS/N D-2698 N8944DFerguson Parker W · Norman, OKBuilt 1966 · S/N D-8285 N8944MEngland Neil Dean Jr Trustee · Watsonville, CABuilt 1965 · S/N D-7940 N8945ADodson International Parts Inc · Rantoul, KSBuilt 1951 · S/N D-2699 N8945UPoeppelman Philip W · Versailles, OHBuilt 1965 · S/N D-7923 N8946UEilers John D · Royal City, WABuilt 1965 · S/N D-7928 N8948UClarke Cheryl A · Oakley, CABuilt 1965 · S/N D-7945 N8950ABeechcraft C-35 Lc · Cameron Park, CABuilt 1951 · S/N D-2704 N8951MZimmerman Bruce M · Crittenden, KYBuilt 1964 · S/N D-7338

Back to AD 94-20-04 R2