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.

N362TBarnett Blake C · Boynton Beach, FLBuilt 1977 · S/N D-10025 N362ZKinder Jeffrey · Richland, WABuilt 1960 · S/N D-6522 N3632APauly Adam · Macomb, MIBuilt 1969 · S/N D-9081 N36363Klein John · Woodland, CABuilt 1975 · S/N D-9748 N363BShoal Properties LLC · Bokeelia, FLBuilt 1957 · S/N D-5087 N363BCBig Cha Inc · Wilmington, DES/N D-9763 N363ZN363z Flyers LLC · Lenexa, KSBuilt 1960 · S/N D-6526 N364TJohnsons Ag-Air Inc · Tyler, MNBuilt 1962 · S/N D-7045 N3650AMcclain Aviation LLC · Newark, DEBuilt 1969 · S/N D-9077 N365BMiles Barrington K · Austin, TXBuilt 1957 · S/N D-4995 N3676YYesco Administration LLC · Salt Lake City, UTBuilt 1980 · S/N D-10306 N368BVinnola Bruce L · Glenrock, WYBuilt 1957 · S/N D-5107 N3692ABva Bonanza LLC · Keizer, ORBuilt 1969 · S/N D-9091 N3693AC And F Enterprise L L C · Milford, MIBuilt 1964 · S/N D-7384 N36AOral & Maxillofacial Surgery Of Carbondale Inc · Carbondale, ILBuilt 1958 · S/N D-5451 N36MZWestfall Thadd W · Three Lakes, WIBuilt 1966 · S/N D-8378 N3702QBonander Jeremy Ray · Tucson, AZBuilt 1966 · S/N D-8363 N3704QRipley Robert G · Griffin, GABuilt 1966 · S/N D-8365 N3705QCourts Data Center Consulting LLC · Lakeway, TXBuilt 1967 · S/N D-8419 N3706QSteed George W III · Silverdale, WABuilt 1966 · S/N D-8367 N3707QTroutman Shaun · Johnson, KSBuilt 1966 · S/N D-8368 N3713QAirborne Adventures LLC · Clive, IABuilt 1966 · S/N D-8370 N3715QShellington Justin R · Columbus, NJBuilt 1966 · S/N D-8375 N371BBtf Ventures LLC · Kalispell, MTBuilt 1957 · S/N D-5069 N3720QM M & O Aviation Inc · Northglenn, COBuilt 1966 · S/N D-8373 N3728AAc Bonanza LLC · Carrollton, TXBuilt 1969 · S/N D-9084 N372BSchmalhaus Rodney · Garfield, ARS/N D-5101 N3731QMoore J D · Lawson, MOBuilt 1966 · S/N D-8374 N3735BBas Part Sales LLC · Greeley, COBuilt 1982 · S/N D-10403 N373GTCruisaire Inc · Port Orange, FLBuilt 1957 · S/N D-5395 N373TBarker Philippe · San Leon, TXBuilt 1963 · S/N D-7138 N373ZEvans Dale A · Green Cove Springs, FLBuilt 1960 · S/N D-6550 N3748QThoendel Jason · Saint Charles, MOBuilt 1967 · S/N D-8411 N374TOtt James D · Kilgore, TXBuilt 1966 · S/N D-8165 N374ZZulu Golf LLC · Yukon, OKBuilt 1960 · S/N D-6554 N3753QMintz Jason · Houston, TXBuilt 1967 · S/N D-8393 N3759QJ & C Companies LLC · Mesa, AZBuilt 1967 · S/N D-8394 N3762QHarris Randal Glenn · Sedona, AZS/N D-8398 N3763QOrr Robert · San Clemente, CABuilt 1967 · S/N D-8399 N3770QTaylor Zachary S · Shawnee, OKBuilt 1967 · S/N D-8403 N3772QBoav8r LLC · Marana, AZBuilt 1967 · S/N D-8405 N3781QWelch Michael R · Roanoke, TXBuilt 1967 · S/N D-8417 N3785QGo Fly Missoula LLC · Missoula, MTBuilt 1967 · S/N D-8413 N3787DGlittenberg Bryson S · Rowlett, TXBuilt 1954 · S/N D-3787 N3788QSale Reported · Oklahoma City, OKSale reported, canceledBuilt 1967 · S/N D-8410 N3789QHercules Jesse T · Memphis, TNS/N D8412 N378BJenkins Kenneth S · Milton Freewater, ORS/N D-5156 N378JRay Preston C · Chula Vista, CABuilt 1967 · S/N D-8421 N378TCampisi James R · Senoia, GABuilt 1963 · S/N D-7149 N3793QMartin Tully T · Idalou, TXBuilt 1967 · S/N D-8418

Back to AD 94-20-04 R2