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.

N40SKSides Family Management LLC · El Paso, TXBuilt 1979 · S/N 414A0323N41019Sjs Flights Lp · Columbus, GABuilt 1973 · S/N 421B0401N41041Mathews Christopher D · Blue Earth, MNBuilt 1973 · S/N 421B0412N41055J&B Aircraft LLC · Anaheim, CABuilt 1974 · S/N 421B0576N41085421 Bravo LLC · Marine City, MIS/N 421B0440N410AJSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 421C1093N410ECSoutheast Enterprises LLC · Dothan, ALBuilt 1973 · S/N 421B0422N410NFMurphy Aviation Inc · Gilroy, CABuilt 1978 · S/N 414A0102N41106Delorenz Robert J · Boca Raton, FLBuilt 1974 · S/N 421B0589N41114Iacobacci Timothy R · Fairborn, OHBuilt 1973 · S/N 421B0458N41124Wenta Nip & Sanitizing LLC · Monte Vista, COBuilt 1973 · S/N 421B0465N411ABAmerican Time Machine LLC · Edmond, OKBuilt 1980 · S/N 414A0524N411CKFairchild Bill R · Dalhart, TXS/N 421C0229N411DCWillert Fred J · San Diego, CABuilt 1965 · S/N 411-0135N411MZSongbird Air LLC · Lakewood, COBuilt 1980 · S/N 421C1002N411TBLewis Nathan · North Plains, ORS/N 421B0481N411VGMontala Investments LLC · Montgomery, ALBuilt 1981 · S/N 414A0675N411ZJkdj LLC · Tyler, TXBuilt 1973 · S/N 421B0482N412CAAirswiss Inc · Wilmington, DES/N 402C0005N413BMLee Aviation LLC · Sheridan, ARBuilt 1977 · S/N 414A0004N413VVGardner John · New Hudson, MIBuilt 1979 · S/N 421C-0641N414ACBirman Pablo · Suamico, WIBuilt 1975 · S/N 414-0820N414AFSano Aviation Corp · Lewes, DEBuilt 1971 · S/N 414-0167N414AKValiair Lc Trustee · Casper, WYBuilt 1979 · S/N 414A0321N414AMToucan Aviation LLC · Lafayette, LABuilt 1982 · S/N 414A0850N414APLiving Word Ministries Inc · Shreveport, LAS/N 414-0512N414AQQualitair LLC Trustee · MichelstadtBuilt 1974 · S/N 414-0472N414ARFlight Med LLC · Cumming, GABuilt 1976 · S/N 4140902N414ATCreekmore Arnold · Somerset, KYBuilt 1978 · S/N 414A0209N414AVChoate Oilfield Services LLC · Hennessey, OKS/N 414A0294N414AWAlycone Trust Corp Trustee · Wichita, KSS/N 4140520N414BTrojan Enterprises LLC · Dover, DES/N 414A0109N414BAOptimal Health Systems LLC · Pima, AZBuilt 1970 · S/N 414-0047N414BBDougherty Forestry Manufacturing Ltd Co · Hinton, OKS/N 414A0839N414BDBostater Charles Jr · Indn Hbr Bch, FLBuilt 1973 · S/N 414-0430N414BGGreen Forest Aviation LLC · Edmond, OKBuilt 1978 · S/N 414A0094N414BLBig South Fork Aero Inc · Huntsville, TNBuilt 1978 · S/N 414A0115N414BMBorden John · Raleigh, NCBuilt 1974 · S/N 414-0532N414BPN414bp LLC · Valley Center, KSS/N 414A0506N414BRQualitair LLC Trustee · MichelstadtS/N 414A0282N414BSHunger Relief Ministries · Forney, TXBuilt 1980 · S/N 414A0504N414BTCmo Blue Sky LLC · Tomball, TXBuilt 1978 · S/N 414A0048N414BWSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1978 · S/N 414A0049N414CASurgeon LLC · Arcadia, LABuilt 1980 · S/N 414A0479N414CDRepinter (Delaware) Inc · Coral Gables, FLBuilt 1972 · S/N 414-0357N414CELocaero Services Inc Trustee · Wilmington, DEBuilt 1976 · S/N 414-0904N414CLL Squared Aviation LLC · Marine, ILBuilt 1977 · S/N 414A0003N414CMMartin Livestock LLC · Ione, CABuilt 1980 · S/N 414A0472N414CNAllied Asset Management LLC · Oklahoma City, OKBuilt 1978 · S/N 414A0035N414CRAga Aviation LLC · Woodruff, SCBuilt 1975 · S/N 414-0629
Back to AD 2018-03-03 R1