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.

N331TCOn Trend Homes LLC · Columbia, MOS/N 414-0943N333AMLally Glen Joseph · Pleasanton, CABuilt 1975 · S/N 414-0651N333CJDrj Aviation LLC · Dover, DEBuilt 1972 · S/N 421B0313N333HHJohnson Craig A · Canton, TXS/N 414-0942N333KWD G R Air LLC · Braselton, GABuilt 1974 · S/N 421B0657N333PWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1980 · S/N 414A0525N333SFFerretti James L III · Port Orange, FLBuilt 1967 · S/N 411-0260N333UJUgly Johns Aircraft LLC · Afton, OKBuilt 1983 · S/N 425-0179N334NCarter-Muthana Aero LLC · Bakersfield, CABuilt 1978 · S/N 421C0458N335CMPura Plastic Surgery LLC · Doral, FLBuilt 1980 · S/N 414A0418N3377QMendez Jr Leo · Corpus Christi, TXS/N 421B0261N337PLMaglaughlin Ronald D · Udall, KSBuilt 1969 · S/N 402A0039N3398QRiebe Grover C Jr · Gwinner, NDBuilt 1969 · S/N 421A0108N33ADSouthern Turf Services LLC · West Palm Beach, FLBuilt 1973 · S/N 414-0412N33UWPadf LLC · Fort Collins, COS/N 421C0676N33WVInarayan Inc · Winter Park, FLS/N 414A0082N341RBRomeo Bravo LLC · Thompson, MOS/N 421C1112N342RCHyland'S Pharmacy LLC · Wheeler, TXBuilt 1982 · S/N 421C-1243N344TCInternational Air Services Inc Trustee · Carson City, NVS/N 421C0424N345TPJet-Force One LLC · Aledo, TXS/N 425-0005N346CHAce Flight Center Inc · St Thomas, VIBuilt 1979 · S/N 402C0029N347ABTropical Transport Services Ltd Inc · San Juan, PRBuilt 1980 · S/N 402C0347N34ADPremiere Aviation Inc · Concord, CABuilt 1975 · S/N 421C-0036N34AGJ D Aviation Leasing LLC · Mundelein, ILS/N 421C0901N34MMSchubee Air Inc · Watkins, COBuilt 1967 · S/N 401-0125N350GMCannonball Trucking Inc · Houston, TXBuilt 1978 · S/N 414A-0120N351ABTropical Transport Services Ltd · San Juan, PRBuilt 1980 · S/N 402C0351N351HCBig Elk Aviation LLC · Elk City, OKS/N 414A0801N352TSBoss Contract Services LLC · Terry, MTBuilt 1972 · S/N 414-0352N353ESNeptune Assets 1 LLC · Lewes, DEBuilt 1982 · S/N 425-0158N353TSExceptional Housing LLC · Hendersonville, TNBuilt 1984 · S/N 425-0221N3540MDybel William P · Frankfort, ILS/N 421B0472N355RTBeechwood Aviation LLC · Wilmington, DEBuilt 1974 · S/N 421B0633N35FSSelistli LLC · San Mateo, CABuilt 1974 · S/N 421B0831N35TYAlpha Aero LLC · Dover, DES/N 425-0088N35VCGomez Victor · Isabela, PRBuilt 1969 · S/N 401A0126N361GCFff Leasing LLC · Dover, DES/N 414-0616N365FDci Air LLC · Dodge City, KSBuilt 1980 · S/N 421C0854N366MN366m LLC · Dover, DES/N 414A0026N366MCHastings Steve T · Corpus Christi, TXS/N 414A1005N36887Aa Aircraft Adventure LLC · Joplin, MOBuilt 1982 · S/N 414A0835N36908Williams D Eric · Palm Springs, FLBuilt 1980 · S/N 402C0313N36911Hyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0314N36961Alpha 414a LLC · New Smyrna Beach, FLBuilt 1980 · S/N 414A0494N369RKKrum Force 1 LLC · Wichita, KSBuilt 1976 · S/N 421C0072N369RMRothschild Jonathan Trustee · Tucson, AZBuilt 1976 · S/N 421C0071N37181Jrs Aviation LLC · Falls City, NEBuilt 1980 · S/N 414A0511N371SBN333bc LLC · Franktown, COS/N 421C1072N37404Bear Giant LLC · Eden Prairie, MNBuilt 1977 · S/N 421C0339N37417Registered aircraftS/N 421C0344
Back to AD 2018-03-03 R1