Registered aircraft · 18,495

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.

N98MWSmith William E Jr · Havre De Grace, MDBuilt 1988 · S/N CE-1228 N98PBFerry Services Corp · Cresson, TXBuilt 1977 · S/N 18503489 N98RCPegasus LLC · Farmington, NMBuilt 1973 · S/N 340-0187 N98RETwin Star Hot Springs LLC · Hot Springs, ARBuilt 1977 · S/N TJ-108 N98RFDabosa LLC · Bernville, PABuilt 2003 · S/N 0520 N98SDMjbk Adventures LLC · Monrovia, INBuilt 1980 · S/N 310R1872 N98VCVictor Adventures LLC · Ottawa, OHBuilt 1998 · S/N E-3170 N98WENorthern Aviation LLC · Roberts, MTBuilt 1997 · S/N E-3146 N9900GSkyline Agrinautics Inc · Osage, IABuilt 1970 · S/N 18800700 N9909ZLake And Peninsula Airlines Inc · Port Alsworth, AKBuilt 1983 · S/N U20606740 N990BSYanish Ronald L · Goodland, FLBuilt 2004 · S/N 1061 N990CDWertsberger Shalom · Rochester, NYBuilt 2004 · S/N 1087 N990JBMurphy George E · Robinson, ILBuilt 1977 · S/N 340A0370 N990MDMelchiorre Joseph G · Lewes, DEBuilt 1964 · S/N D-7527 N990PValli Air LLC · Leonardtown, MDBuilt 2004 · S/N 0945 N990PCCmm Enterprises LLC · Pharr, TXBuilt 1974 · S/N 414-0546 N990TSKem Investments LLC · Wichita, KSBuilt 1990 · S/N CE-1537 N990USimpson Reed · Marco Island, FLBuilt 1965 · S/N 21058690 N9910MSatran Paul C · Detroit Lakes, MNBuilt 1977 · S/N 21062089 N9910NRunner Douglas A · Ashby, NEBuilt 1982 · S/N 18504370 N9913MVillapudua Ruben Ruiz · Phoenix, AZBuilt 1977 · S/N 21062090 N9914TRegistered aircraftBuilt 1969 · S/N CE-285 N9915DEvery Time Aviation LLC · Lake Havasu City, AZS/N 29-0090 N9916ZWings Of Wisconsin LLC · New Richmond, WIS/N U20606744 N991AAHyannis Air Service Inc DBA · Hyannis, MABuilt 1980 · S/N 402C0317 N991DVance William F · Belgrade, MTBuilt 1966 · S/N TE-222 N991GJIsland Charter LLC · Wilmington, DEBuilt 1979 · S/N 310R1803 N991PMSandy Herd LLC · Amarillo, TXBuilt 2005 · S/N 1601 N9922YInfinite Wings LLC · Henderson, NVBuilt 1982 · S/N 21064640 N9923YPostupack Peter Jr · New Cumberland, PABuilt 1982 · S/N 21064641 N9923ZChena River Aviation Inc · Fairbanks, AKBuilt 1983 · S/N U20606747 N9924RInzer James Clarence IV · Baton Rouge, LABuilt 1986 · S/N U20606983 N9925GPetecraft Aviation Services Inc · Plains, GABuilt 1971 · S/N 18800725 N9925TFly Bravo LLC · Jasper, TXBuilt 1966 · S/N TE-224 N9928FWatermaster Irrigation Supply Inc · Lubbock, TXBuilt 1972 · S/N 340-0165 N9928NScott J Steve Jr · Itta Bena, MSBuilt 1977 · S/N U20603730 N9928YEckelkamp L B Jr · Washington, MOBuilt 1982 · S/N 21064643 N992CBaker Clark D · Great Bend, KSS/N L2K-312 N992KN992k LLC · Napa, CABuilt 2005 · S/N 1600 N992LKIcc Aviation LLC · Belleville, MIBuilt 2003 · S/N 0610 N992POdom Johnny C · Fredericksburg, TXBuilt 1977 · S/N 310R1210 N992PSProctor Gary · Wichita, KSBuilt 1978 · S/N 21063074 N9930QBrawdy James · Clarence Center, NYBuilt 1979 · S/N 18503798 N9932GT & M Aircraft LLC · Monticello, ILBuilt 1971 · S/N 18800732 N9932ZSilver Creek Aviation Services · Fort Worth, TXBuilt 1983 · S/N U20606753 N9933MAlaska Aircraft Leasing LLC · Silverdale, WABuilt 1982 · S/N 20700750 N9933ZFreelance Air · Kennesaw, GABuilt 1983 · S/N U20606754 N9934XLogue James · Fort Worth, TXBuilt 1975 · S/N 21060916 N9934ZParagon Air Group · Fort Worth, TXBuilt 1983 · S/N U20606755 N9935MFreshwater Adventures Inc · Dillingham, AKBuilt 1982 · S/N 20700751

Back to AD 86-13-04 R3