OpenAirDocs.org
AD 2018-03-03 R1

Registered aircraft · 1,770

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

N617CCRiley Livestock Inc · Mayfield, KYS/N 421C0897N618CAHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0620N619ACFeed Yard Industrial Solutions LLC · Amarillo, TXBuilt 1977 · S/N 421C0336N61AJCoco Air Ltd Trustee · Wilmington, DEBuilt 1978 · S/N 421C0457N61JV61jv LLC · Chuckey, TNS/N 421C0097N620CAFar West Leaseco LLC · Kalispell, MTS/N 414-0916N622TRL C A Inc · Alamo, CABuilt 1980 · S/N 421C0858N6249QKnudsen Russell G · East Troy, WIBuilt 1969 · S/N 401A0049N624CAClarke Cecil Jr Trustee · Katy, TXBuilt 1975 · S/N 402B0876N624PKBas Part Sales LLC · Greeley, COBuilt 1971 · S/N 421B0144N6255QValiair Limited Company Trustee · Casper, WYBuilt 1969 · S/N 401A0055N625JLTurbulent Returns LLC · Minneapolis, MNBuilt 1980 · S/N 414A0508N626DRK And L Transportation LLC · Carterville, ILFirst renewal noticeS/N 421C0512N6272TBernaiche Travis · Caribou, MEBuilt 1969 · S/N 421A0141N628CMav Air LLC · Rigby, IDBuilt 1981 · S/N 425-0041N628JWSouthern Edge Aviation LLC · Blue Ridge, VABuilt 1979 · S/N 414A0241N628MRRichard Chevrolet Inc · Monterey, MABuilt 1981 · S/N 425-0049N628RJJanak Jeffrey · Corpus Christi, TXBuilt 1974 · S/N 421B-0503N629WMVortech LLC · Woodbury, NYS/N 421C1001N62DWSagamore Sky LLC · Jericho, NYS/N 4210188N62JCChuoke Joseph P · Texas City, TXS/N 421C0498N630ADT Machine LLC · Livingston, MTBuilt 1977 · S/N 421C0406N6315XEagle Aviation LLC · Morristown, TNBuilt 1981 · S/N 421C1003N633MCSveen Jeffrey T · Aberdeen, SDBuilt 1979 · S/N 421C0657N635MAAirswiss Inc · Wilmington, DES/N 402C0634N6375XMiliano Air LLC · Lewes, DEBuilt 1978 · S/N 402B1338N6384XPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1978 · S/N 402B1347N6387XAir Exec Inc · Mount Pleasant, IABuilt 1978 · S/N 402B1350N6396XAviation Tech Services LLC · Edgewater, FLBuilt 1978 · S/N 402B1355N639SCSale Reported · Glen Allen, VASale reportedBuilt 1969 · S/N 421A0102N63CXAerodata LLC · Wilmington, DES/N 4140388N63DBDelta Properties Llp · Nogales, AZS/N 414A1211N643WMBarham Investments LLC · Dexter, MOBuilt 1985 · S/N 414A1205N645SBN645 Shares LLC · Liberal, KSBuilt 1984 · S/N 425-0217N645WCWest Louis G · Amity, ORBuilt 1975 · S/N 414-0645N648SBHays Kelly · Dumas, TXBuilt 1979 · S/N 421C0648N650BDV1vr LLC · Saint Louis, MOBuilt 1979 · S/N 414A0404N650DBValiair Limited Company Trustee · Casper, WYBuilt 1982 · S/N 414A0853N650RMAcci Aviation LLC · Conway, ARBuilt 1978 · S/N 414A0031N6561CTrtc Aviation LLC · Byron Center, MIBuilt 1977 · S/N 414A0014N6578CPapoose Air II LLC · Wilmington, DEBuilt 1978 · S/N 414A0020N657WMRegistration Pending · Carlsbad, NMRegistration pendingS/N 421C0474N6597CHai Services Inc · Haltom City, TXBuilt 1978 · S/N 414A0028N6599GPremiere Aviation Inc · Concord, CAS/N 421C0275N659RJFoerstel Edward · Miami Beach, FLBuilt 1984 · S/N 421C1408N65AEMorris Charles J · Rutherford, TNBuilt 1975 · S/N 421B0953N65RPE-Co Aviation LLC · Wilmington, DEBuilt 1979 · S/N 414A0287N660CABank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 402C0406N6614CBg Air Corp · Wilmington, DEBuilt 1978 · S/N 414A0032N6631CD Porter Enterprises LLC · Dickinson, NDBuilt 1978 · S/N 414A0038
Back to AD 2018-03-03 R1