Registered aircraft · 18,497

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:86-13-04-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3') 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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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:86-13-04-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
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.

N421EEBas Part Sales LLC · Greeley, COBuilt 1979 · S/N 421C0692 N421EQEquus Air LLC · Norman, OKS/N 421C0910 N421EWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1975 · S/N 421C0034 N421EZN421ez LLC · Paw Paw, ILBuilt 1974 · S/N 421B0608 N421FAAll In Aviation LLC · Longview, TXBuilt 1973 · S/N 421B0431 N421FMAxis Aviation LLC · Cape Canaveral, FLBuilt 1974 · S/N 421B0841 N421FZBamert Brett L · Muleshoe, TXBuilt 1981 · S/N 421C1020 N421GShapiro David Michael · Homer, AKS/N 421C0664 N421GCBtc Enterprises LLC · Wilmington, DEBuilt 1975 · S/N 421B0926 N421GEMels Priced Right Custom Carts · Lakeland, FLBuilt 1970 · S/N 421B0109 N421GGScientific Flight Corp · Shorewood, ILBuilt 1974 · S/N 421B0848 N421GHArx Aviation LLC · Apopka, FLBuilt 1973 · S/N 421B-0483 N421GJAeroventures 8 LLC · Mount Carmel, TNS/N 421C0815 N421GKK2 Aviation LLC · Sanford, NCBuilt 1981 · S/N 421C1053 N421GL421 Partners Georgia LLC · Chatsworth, GABuilt 1984 · S/N 421C1405 N421GMCjk Investment Holdings LLC · Tallahassee, FLBuilt 1976 · S/N 421C0159 N421GPCircle Capital Industrial Iac LLC · Dover, DEBuilt 1977 · S/N 421C0259 N421GSStarlight Aviation LLC · Houston, TXBuilt 1984 · S/N 421C1409 N421GWGrinnell Allen L · Derry, NHBuilt 1974 · S/N 421B0873 N421HLDodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N 421C0820 N421HPDodson International Parts Inc · Rantoul, KSBuilt 1980 · S/N 421C0831 N421HRRons Air Service Inc · Two Buttes, COS/N 421B0945 N421HSQualitair LLC Trustee · MichelstadtBuilt 1979 · S/N 421C0621 N421J421j LLC · Chuckey, TNS/N 421C0208 N421JCLonestar Aviation LLC · Las Cruces, NMBuilt 1981 · S/N 421C1099 N421JEBrown Lawson M II DBA · San Diego, CABuilt 1981 · S/N 421C1057 N421JLWagner Distributing Co Inc · Auburn, CABuilt 1977 · S/N 421C0210 N421JMSchuck James M · Downey, CABuilt 1975 · S/N 421B0956 N421JR421jr LLC · Wichita, KSBuilt 1976 · S/N 421C-0094 N421JSBank Of Utah Trustee · Salt Lake City, UTBuilt 1975 · S/N 421C0033 N421JTPetty Flying Service Inc · Munday, TXBuilt 1979 · S/N 421C0666 N421JWWheels Up Aviation LLC · Edmond, OKBuilt 1979 · S/N 421C0665 N421KMWeatherproof Montana LLC · Missoula, MTBuilt 1976 · S/N 421C-0006 N421KSEnvironmental Manufacturing Solutions Ltd · Melbourne, FLBuilt 1973 · S/N 421B0507 N421LCApi Aviation Leasing LLC · North Venice, FLBuilt 1975 · S/N 421C0053 N421LEN421le LLC · High Springs, FLS/N 421C0464 N421LFHaynes Aviation LLC · Caruthersville, MOS/N 421C0059 N421LKParadise Flyers LLC · Summerland Key, FLBuilt 1981 · S/N 421C1017 N421LLWhirlybird Aviation LLC · Bend, ORBuilt 1983 · S/N 421C1081 N421LQApex A & K LLC · Englewood, FLBuilt 1980 · S/N 421C0883 N421LYMayes John S · Austin, TXBuilt 1980 · S/N 421C0855 N421MCBlue Bottom Inc · Los Angeles, CABuilt 1972 · S/N 421B0321 N421MDBoss Contract Services LLC · Terry, MTBuilt 1978 · S/N 421C0516 N421MEMeisner Aircraft Inc · Janesville, WIBuilt 1976 · S/N 421C0074 N421MLLps Utilities Inc DBA · Woodstock, ILBuilt 1981 · S/N 421C0880 N421MRQuest Aviation Inc · Lake City, FLBuilt 1968 · S/N 421-0112 N421MUN421mu LLC · Missoula, MTBuilt 1977 · S/N 421C0248 N421MWRice Melvin Gaylon · Bridgeport, TXBuilt 1968 · S/N 421-0058 N421MYOzark Trails Youth Services Inc · West Plains, MOS/N 421B-0356 N421PFNorthwest Georgia Aviation LLC · Rome, GAS/N 421B0400

Back to AD 86-13-04 R3