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.

N3899BJohnston Robert M · Plantation, FLBuilt 1955 · S/N D-4135 N389MCCarstetter Melvin D · Lakebay, WABuilt 1978 · S/N D-10150 N389SLively Kirk D · Cresson, TXBuilt 1969 · S/N D-9083 N389ZSmith Daniel P · Saint George, UTBuilt 1960 · S/N D-6561 N38BTMccully Bruce F · Nashville, TNS/N D-7261 N38DKCullinan Robert B · Rch Palos Vrd, CABuilt 1965 · S/N D-7899 N38RDBowser Adam L · Lake City, FLBuilt 1954 · S/N D-3868 N390BMontoya Aviation LLC · Glenview, ILBuilt 1957 · S/N D-4974 N390HWRojecki Stephen T Trustee · Navarre, FLBuilt 1967 · S/N D-8608 N3910ARzepka Rick · Solon, OHBuilt 1970 · S/N D-9093 N391ZKeene Keith · Houston, TXBuilt 1960 · S/N D-6558 N392BBowling Gregory · Floresville, TXBuilt 1957 · S/N D-5282 N392SPlocher Corey · Port Orchard, WABuilt 1968 · S/N D-8752 N393TIronhawk Aviation LLC · Indianapolis, INBuilt 1963 · S/N D-7166 N3952ARegistered aircraftBuilt 1969 · S/N D-9090 N3957ARegistration Pending · Denton, TXRegistration pendingBuilt 1970 · S/N D-9186 N3958AHinton Richard D · Colleyville, TXBuilt 1970 · S/N D-9194 N395ZSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1960 · S/N D-6566 N396PMHansen Donald · Big Lake, MNBuilt 1963 · S/N D-7195 N398CBone Randall E · Weatherford, TXBuilt 1958 · S/N D-5571 N398LTHogan William · Deer Lodge, MTBuilt 1964 · S/N D-7406 N399BWilliams Jack J · Jasper, GABuilt 1957 · S/N D-5009 N399LT5280 High Corp · Wilmington, DEBuilt 1962 · S/N D-6951 N399PTDethomas John V Trustee · Boise, IDBuilt 1968 · S/N D-8727 N3BGHildreth James D · Kennedy, ALBuilt 1967 · S/N D-8612 N3BRSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1973 · S/N D-9447 N3BW4rc LLC · Kenedy, TXBuilt 1976 · S/N D-9870 N3DXMchugh Michael J Trustee · Hailey, IDBuilt 1973 · S/N D-9531 N3HFHughes Farms Inc · Fayette, MOBuilt 1975 · S/N D-9791 N3JFBruegget Shannon B · Lance Creek, WYBuilt 1958 · S/N D-5628 N3JWJason Flood · Vineland, NJBuilt 1964 · S/N D-7591 N3MDMcdavid James J · Weatherford, TXBuilt 1965 · S/N D-7856 N3MJLarsh Steven S · Libby, MTBuilt 1956 · S/N D-4894 N3MYLee Brian E · Peoria, AZBuilt 1974 · S/N D-9661 N3SVYoung Karen Sue · Cincinnati, OHBuilt 1967 · S/N D-8426 N3XTHammock Jerry G · Waxahachie, TXBuilt 1970 · S/N D-9156 N4004APrice Jason R · Lillington, NCBuilt 1970 · S/N D-9098 N400LFBoboltz Randy · Hector, MNBuilt 1975 · S/N D-9825 N400PBonanza V35 LLC · Bakersfield, CABuilt 1976 · S/N D-9933 N400RCSpiwak Andrew J · Canyon Lake, TXBuilt 1972 · S/N D-9312 N400VHalford John · Ballinger, TXBuilt 1973 · S/N D-9535 N400WEOberti Gary A · Hillsborough, CABuilt 1975 · S/N D-9814 N4010ARegistered aircraftBuilt 1970 · S/N D-9099 N4013AGeoghagan Dewayne · Indianapolis, INBuilt 1970 · S/N D-9115 N4042ARogden Aviation Inc · San Rafael, CABuilt 1970 · S/N D-9102 N4043AByard Jeffrey G · Carson City, NVBuilt 1970 · S/N D-9103 N4045AWdw Aviation Leasing Inc · Knoxville, TNBuilt 1970 · S/N D-9104 N404MDDent Thomas E · Moses Lake, WABuilt 1964 · S/N D-7437 N404VDevine Timothy P · Roseville, CABuilt 1962 · S/N D-6981 N4059SKramer Harvesting LLC · Johnson, KSBuilt 1974 · S/N D-9705

Back to AD 94-20-04 R2