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.

N581CJDodson International Parts Inc · Rantoul, KSS/N 421B0343N5826CBank Of Utah Trustee · Salt Lake City, UTBuilt 1979 · S/N 402C0050N583DWKinetic Systems Inc · Richmond Hill, GABuilt 1973 · S/N 421B0583N585PASaltzy Seas LLC · West Palm Beach, FLBuilt 1981 · S/N 425-0047N5874CVola Acosta LLC · Lake Forest, CAS/N 421C0882N587MWHammonds Mark · N Richlnd Hls, TXBuilt 1974 · S/N 421B0587N5882TDe Smet Vicki M · La Verne, CAS/N 421B0424N588TBVlot Cole T · Wellington, NVBuilt 1976 · S/N 421C0064N589STCurtis & Son Vacuum Service Inc · Liberty, TXS/N 421C0644N58AWAmplatz Left Aviation LLC · Rapid City, SDS/N 414A0276N58HBjk Aviation LLC · Morgantown, WVBuilt 1979 · S/N 414A0314N58ZPCk Investor Inc · Lubbock, TXS/N 421C0705N5916MQuest Aviation Inc · Lake City, FLBuilt 1973 · S/N 402B0365N593DMLister John · Pipe Creek, TXS/N 402B1228N5949MSnflk Leasing LLC · Andrews, TXBuilt 1972 · S/N 421B0319N5962MKitov Resources Corp · Shorewood, WIS/N 421B0205N5967MN5967m LLC · Chantilly, VAS/N 421B0210N596DMAirswiss Inc · Wilmington, DES/N 402C0255N5975JFreeland Christopher G · Brownwood, TXS/N 414-0028N5988MSaltzer Eric · Somerton, AZBuilt 1972 · S/N 421B0231N598ASAssociated Auction & Liquidation Co · Clarksburg, TNBuilt 1984 · S/N 414A1003N598DMAirswiss Inc · Wilmington, DEBuilt 1979 · S/N 402C0114N5996MMedcare Emergency Medical Services Inc · Mcallen, TXBuilt 1972 · S/N 421B0334N59NMGf Air LLC · Las Vegas, NVBuilt 1975 · S/N 421B0870N5AMTexas La Flyers LLC · West Monroe, LAFirst renewal noticeBuilt 1979 · S/N 414A0441N5CEAvion Capital Corp · Anchorage, AKBuilt 1981 · S/N 425-0135N5CHHartshorn William T · Tucson, AZBuilt 1968 · S/N 421-0113N5CNLewis Gentry Holdings LLC · Orlando, FLBuilt 1978 · S/N 414A0073N5NMNelson Jeffrey S · Darby, MTBuilt 1978 · S/N 414A0042N5NNRkgrier LLC · Beckley, WVS/N 421C0446N5PJGod Family Ministries International Inc · Elmont, NYBuilt 1972 · S/N 421B-0258N5UTK&L Salty Air LLC · Stephenville, TXBuilt 1976 · S/N 421C0101N5ZTAllen Airplane LLC · Durango, COBuilt 1973 · S/N 414-0477N600DCHerron Aviation Group LLC · Dexter, MIS/N 421C1007N600HCCessna 414a LLC · Portland, ORBuilt 1978 · S/N 414A0025N600THN600th LLC · Fredericksburg, VABuilt 1981 · S/N 414A0668N602DCKeystone Xpress LLC · Rostraver Twp, PAS/N 421C0864N605DCT&C Aviators LLC · Green Cove Springs, FLS/N 421C-1005N605SRPlane Fun Inc Tr Trustee · Snellville, GABuilt 1981 · S/N 421C1041N606PPAndriopulos Salguero Inc · Hialeah, FLS/N 414-0416N607JDJd 707 Air LLC · Edgerton, OHBuilt 1978 · S/N 414A0071N60GMInternational Air Services Inc Trustee · Carson City, NVS/N 421C-0828N6115CHat Investments LLC · Spartanburg, SCS/N 421C0890N612CGCasa Grande Homes Inc · Blanchard, OKBuilt 1973 · S/N 421B0416N6161XGolden Eagle Aircraft LLC · Boulder, COS/N 421C0895N6161ZSkybound Holdings LLC · Orlando, FLBuilt 1978 · S/N 414A0019N616DFugate Kirk A · El Dorado Springs, MOS/N 421B0140N616MGSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 425-0087N616RMMnemonics Inc · Melbourne, FLBuilt 1973 · S/N 414-0375N616STK&S Flights LLC · Sweet Valley, PABuilt 1981 · S/N 414A0806
Back to AD 2018-03-03 R1