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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N8195QD&M Enterprise LLC · Wilmington, DEBuilt 1970 · S/N 414-0095 N819RARonald Jinsky LLC · Beloit, WIBuilt 1978 · S/N 421C0522 N81ADMr Dent Inc · Manheim, PAS/N 401A0023 N81LPSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1981 · S/N 421C-1083 N81RDPapaco LLC · Green Cove Springs, FLS/N 421C0291 N821KAKa Consulting LLC · San Juan, PRBuilt 1981 · S/N 421C1203 N821TTHome By Dark LLC · Fredericksburg, TXBuilt 1976 · S/N 421C0041 N8221QSouthwest Aircraft LLC · Fairacres, NMBuilt 1971 · S/N 414-0151 N8223QBas Part Sales LLC · Greeley, COS/N 414-0153 N8229QSeppala Wayne H Trustee · El Cajon, CABuilt 1971 · S/N 414-0159 N822BKPropilot LLC · San Juan, PRS/N 421C0822 N8241QRolling Hills LLC · Plainfield, ILBuilt 1971 · S/N 4140171 N8243QAnderson Cattle Co Inc · Emporia, KSBuilt 1971 · S/N 414-0173 N824RBShark Water Systems LLC · Hobbs, NMBuilt 1979 · S/N 414A0411 N826CMKuriel Michael · Las Vegas, NVS/N 421C0508 N829EDiaz Maria · Kansas City, MOS/N 401A0014 N82AWQualitair LLC Trustee · MichelstadtBuilt 1978 · S/N 414A0064 N82DAAircraft Holding Solutions LLC Trustee · Newark, DES/N 414A0476 N82GLJusticia Holdings LLC · Roanoke, VAS/N 414A0275 N82TAJanes Paul A · Ontario, ORBuilt 1968 · S/N 402-0156 N82TRExecutive Autopilots DBA · Sacramento, CABuilt 1972 · S/N 414-0273 N831BMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1979 · S/N 414A0340 N831WCEpic Vibes Consulting Group Lp · Princeton, NJS/N 414-0467 N834RMInfinity Properties LLC · Summerset, SDS/N 421C-0834 N8355Premier Plus Aviation Inc · Fort Pierce, FLBuilt 1979 · S/N 421C0668 N8378GPrecision Guidance LLC · Bloomington, ILBuilt 1977 · S/N 421C0310 N83CHLac Aero LLC · Liberal, KSBuilt 1981 · S/N 425-0025 N83DLake Placid Flying Service Inc · Lake Placid, NYBuilt 1981 · S/N 414A-0615 N83DMCavu Operations LLC · Henderson, NVBuilt 1981 · S/N 425-0079 N83JTLewis Thomas · Belton, TXBuilt 1976 · S/N 414-0835 N83PBHyannis Air Service Inc DBA · Hyannis, MABuilt 1980 · S/N 402C0350 N8401ACommercial Property Services Group LLC · Wichita, KSBuilt 1977 · S/N 421C0443 N8422FTownsend David · Piedmont, SCS/N 402-0270 N842DYAltimate Transportaton Services LLC · Dallas, TXFirst renewal noticeBuilt 1977 · S/N 421C0312 N8430NFitch John A · Cary, ILBuilt 1978 · S/N 421C0490 N844CKTurpin Time LLC · Helena, MTBuilt 1979 · S/N 421C0706 N845YCFruscella Alfredo J · Tampa, FLBuilt 1973 · S/N 421B0351 N849JBDodson International Parts Inc · Rantoul, KSS/N 421A0075 N84DAVoorhees Investments Inc · Costa Mesa, CABuilt 1980 · S/N 414A0519 N84PRSkov Equipment Co · Fabens, TXBuilt 1979 · S/N 414A0213 N84RTChannell Robert D · Moreland, GABuilt 1973 · S/N 421B0355 N850RMDueck Arthur P · Lakewood, OHBuilt 1977 · S/N 421C0283 N852TSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1975 · S/N 414-0804 N853MTK & T Inc · Salt Lake City, UTS/N 421C0602 N855HSanford Larry D · Edmond, OKBuilt 1982 · S/N 414A0855 N859DMDavis Mark E · Pearland, TXS/N 421C0859 N85AMLitchfield Lantz Dr · Las Vegas, NVBuilt 1973 · S/N 414-0435 N85KSCnet Aviation LLC · Lindale, TXBuilt 1978 · S/N 421C0525 N860RCCornell Christopher M · Corpus Christi, TXS/N 421B0035 N861HCN861hc LLC · Elk City, OKBuilt 1977 · S/N 421C0438

Back to AD 2018-03-03 R1