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.

N75SKRick Broke Entertainment LLC · Conyers, GABuilt 1974 · S/N 421B0646N75TTReisback Scott · Olalla, WAS/N 414A0405N760RMAircraft Partner Holdings Inc Trustee · BerlinBuilt 1975 · S/N 414-0815N7624QFhs Aero Co · Olathe, KSBuilt 1973 · S/N 421B0363N762CACullum Transportation LLC · North Charleston, SCBuilt 1981 · S/N 421C1214N762TBAero Crafter LLC · Miami, FLBuilt 1977 · S/N 421C0213N763EAHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0497N763JCPilot Services Of Ohio LLC · Loveland, OHBuilt 1976 · S/N 421C0211N764EAHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0237N764PBBisono Pablo R · Guaynabo, PRS/N 402C0338N765FLAviation Angel Tours LLC · Beverly Hills, CABuilt 1975 · S/N 414-0644N767ZRubin Broadcasting Inc · Dallas, ORS/N 421C0401N769EAHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0303N76KTWarriors With Wings LLC · Zebulon, NCBuilt 1974 · S/N 414-0508N76MDNovey Gabriel Antonio · Panama CityNon-citizen corporation, flight hours not reportedBuilt 1977 · S/N 402B1055N76MJJzw Aviation LLC · North Salt Lake, UTBuilt 1981 · S/N 421C1204N76SJRocket Air LLC · Carson City, NVBuilt 1984 · S/N 4250204N770CSFlying Cpa LLC · Colorado Springs, COBuilt 1975 · S/N 421B0877N771EAHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0046N775RCAirswiss Inc · Wilmington, DEBuilt 1980 · S/N 402C0311N777RPParis Air Conditioning Co · Paris, TXBuilt 1974 · S/N 414-0636N777TSEmery Edward F DBA · Bloomsburg, PAFirst renewal noticeS/N 421B0352N777VFZammit Flight Resources LLC · Sheridan, WYBuilt 1977 · S/N 414-0946N77CDN-J Aviation LLC · Forest, VABuilt 1975 · S/N 414-0646N77EPCba Air LLC · Tuscaloosa, ALBuilt 1973 · S/N 421B0478N780JCN780jc Inc · Orlando, FLBuilt 1974 · S/N 421B0582N780MBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1972 · S/N 402B-0249N783MBK-Aero LLC · Farmington, MNBuilt 1982 · S/N 425-0103N784PFMiller Cory L · Winnsboro, TXS/N 425-0018N784TTDodson International Parts Inc · Rantoul, KSBuilt 1981 · S/N 425-0145N7864FKeller Russell L · Runaway Bay, TXBuilt 1968 · S/N 4010207N7875EUniversity Research Foundation · Greenbelt, MDBuilt 1973 · S/N 402B0432N787DRBad Aire LLC · Aledo, TXS/N 414A0503N788JJGreenlee Joseph A III · Fort Wayne, INBuilt 1975 · S/N 421B0851N789PTValiair Limited Company · Casper, WYBuilt 1985 · S/N 414A1209N789RPBrindle Concepts LLC · Hanover, PABuilt 1975 · S/N 421C0009N78DGUsac N78dg LLC · Wall Township, NJBuilt 1981 · S/N 414A-0641N78KC5634 Aviation LLC · Flowery Branch, GABuilt 1978 · S/N 414A-0045N78NGRam Aero Development Inc · Waco, TXS/N 414A0617N7901QKentucky Airmotive Inc · Mount Sterling, KYBuilt 1969 · S/N 401B0001N790XPrecision Design Inc · Weatherford, OKS/N 421A0087N7912QHagan David · Overgaard, AZBuilt 1969 · S/N 401B0012N7913QBrown Kevin B · Eureka, MTBuilt 1969 · S/N 401B0013N7925QWolf River Aviation LLC · Memphis, TNS/N 401B0025N794PCFlioway LLC · Iowa City, IABuilt 1978 · S/N 414A0098N7969QBadenhope John R · Greeneville, TNS/N 401B0109N797RACool Air Travel LLC · Macon, GABuilt 1978 · S/N 414A0119N7983QLorenso Walker Institute Of Technology · Naples, FLBuilt 1971 · S/N 401B0202N7988QCerniglia Paul · Monroe Township, NJBuilt 1971 · S/N 401B0207N7989QLauritano Stephen G · Goodyear, AZBuilt 1971 · S/N 401B0208
Back to AD 2018-03-03 R1