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.

N3092CAhmed Sharfaraz · Houston, TXBuilt 1959 · S/N D-5786 N3092WPrimm Daniel D Jr · Lexington, KYBuilt 1973 · S/N D-9556 N3094CHamllin Jeffry S · Double Oak, TXBuilt 1958 · S/N D-5783 N3095CLittle Karley Y · Baytown, TXBuilt 1958 · S/N D-5774 N3096CGrant Benjamin D · Chesterfield, MIBuilt 1958 · S/N D-5789 N3097CAviation Hangar LLC · Wentzville, MOBuilt 1958 · S/N D-5787 N3099CTurpin Terry S · Foster City, CABuilt 1958 · S/N D-5782 N3099WSavage Curtis Mac · Johnstown, OHBuilt 1973 · S/N D-9561 N309BDavis Kaylee · Port Orange, FLBuilt 1956 · S/N D-4715 N309DCRother Michael V · Granbury, TXBuilt 1979 · S/N D-10309 N30CWBrownd Gregory H · Shallowater, TXBuilt 1958 · S/N D-5636 N30EDN30ed LLC · Carpinteria, CABuilt 1969 · S/N D-9076 N30HMHutchinson Brion M · Crowley, TXBuilt 1954 · S/N D-3853 N30KJCrist Carry R · Crete, NEBuilt 1957 · S/N D-5181 N30MJPrinter & Copier Guys LLC · Corona, CABuilt 1955 · S/N D-4343 N30SFN2wr LLC · Cincinnati, OHBuilt 1956 · S/N D-4832 N30VTPlane Fun Inc Tr (Trustee) · Snellville, GABuilt 1973 · S/N D-9439 N3102WBonanza Leasing LLC · Versailles, KYBuilt 1973 · S/N D-9558 N3111WChubb Oil & Gas LLC · Missoula, MTBuilt 1967 · S/N D-8573 N311BLawrence Guy A · Bakersfield, CABuilt 1955 · S/N D-4424 N311BGBluffton Flying Service Ltd · Bluffton, OHBuilt 1971 · S/N D9276 N311JWBonanza 311 Jw Limited · Urbandale, IABuilt 1959 · S/N D-5925 N3128WSterling Anthony K · Wilson, NCBuilt 1973 · S/N D-9564 N3135WFlycarolina LLC · Concord, NCBuilt 1973 · S/N D-9538 N3138WN3138w Bonanza V35b LLC · Jeffersonville, INBuilt 1973 · S/N D-9566 N313DBHelm Walter · Sacramento, CABuilt 1977 · S/N D-10014 N313DKRoark Norman · Greensburg, INS/N D-4553 N313FFerguson John Edward · Santa Ysabel, CABuilt 1958 · S/N D-5764 N313WWilliams Thomas James · Clovis, CABuilt 1981 · S/N D-10363 N3147WTadesco Rothchild LLC · Wilmington, DEBuilt 1973 · S/N D-9569 N314BM & E Financial Markets Research LLC · Fayetteville, NYBuilt 1956 · S/N D-4788 N315ABColabianchi Bob J · Fountain Hills, AZBuilt 1975 · S/N D-9740 N315BCasteel Robert C DBA · Elk Grove, CABuilt 1956 · S/N D-4866 N3161WPritchard Casey M · Bells, TXBuilt 1973 · S/N D-9572 N3163WSkye Peak Corp · Greenfield, MABuilt 1973 · S/N D-9573 N316BEyefly Az Inc · Hereford, AZBuilt 1956 · S/N D-4811 N316BMPrice John DBA · Bennington, KSS/N D-3268 N317BPeck James L Jr · Shreveport, LABuilt 1956 · S/N D-4816 N317CHCrestair Air LLC · Dover, DEBuilt 1973 · S/N D-9543 N317EPMcelligott Michael J · Woodstock, VABuilt 1969 · S/N D-9044 N317SCDuehring Jonathan H · Raleigh, NCBuilt 1968 · S/N D-8754 N317SWMcnaughton Aviation LLC · Bondurant, IABuilt 1965 · S/N D-7854 N317ZNew William C · Hemet, CABuilt 1960 · S/N D-6540 N3180WPepe Charles · Morrisville, VTBuilt 1974 · S/N D-9574 N3181WNormark Jordan C · Granbury, TXBuilt 1974 · S/N D-9575 N318BRobinson Jay · Red Creek, NYBuilt 1956 · S/N D-4817 N3194CNortje Bryan John · Gold Hill, NCBuilt 1967 · S/N D-8479 N319RFFairfax Ronald E · Hailey, IDBuilt 1974 · S/N D-9663 N31FSStrickland Corp · Onida, SDBuilt 1974 · S/N D-9586 N31JKEquine Associates Inc · Bossier City, LABuilt 1960 · S/N D-6322

Back to AD 94-20-04 R2