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.

N799ESFive Boys Flight Training LLC · Matthews, NCBuilt 1981 · S/N 414A0657 N799TFGallien Anthony · Livermore, CAS/N 421B0324 N79BPOrion 207 LLC · Harpswell, MEBuilt 1979 · S/N 414A0263 N79DCBnb Marine LLC · Miami, FLS/N 414A0212 N79FWDaniel King Aviation LLC · Dover, DEBuilt 1979 · S/N 414A0278 N79JFFour Twenty One LLC · Kalispell, MTBuilt 1977 · S/N 421C0340 N79PPJon Gibson Co · Cameron Park, CABuilt 1980 · S/N 414A0516 N79TDFlying Bs LLC · Canby, ORBuilt 1972 · S/N 421B0325 N7DAJanak Jeffrey · Corpus Christi, TXBuilt 1967 · S/N 402-0084 N800BAN8vv Inc · Corpus Christi, TXBuilt 1981 · S/N 414A0667 N800FSNorads Aerial Services LLC · Leesburg, VAS/N 401A0119 N800KWVenture Air Solutions Inc · Opa Locka, FLBuilt 1976 · S/N 402B1063 N800SMTofanzadeh Abdolreza · Chula Vista, CABuilt 1972 · S/N 421B-0275 N802HLAir Hammer LLC · Wilmington, DES/N 414A0820 N8047QAir Boys Inc · Hayward, WIBuilt 1970 · S/N 421B0047 N805PRValiair Lc Trustee · Casper, WYBuilt 1985 · S/N 414A1206 N8068QCreative Consulting Partners LLC · Fargo, NDBuilt 1974 · S/N 414-0503 N807WSInter Island Freight LLC · Deerfield Beach, FLBuilt 1968 · S/N 4010300 N8085QWes Hughes Corp · Waldron, KSBuilt 1974 · S/N 414-0506 N808BVFlying Dutchman LLC · Waipahu, HIBuilt 1975 · S/N 421C0004 N8091QKhag Aviation Inc · Woodbridge, NJFirst renewal noticeBuilt 1973 · S/N 402B0369 N8093QRobey Sean C · Camden, NCBuilt 1973 · S/N 421B0544 N80JJZing Aviation And Marine LLC · New Smyrna, FLFirst renewal noticeS/N 414A0412 N80LGTru North Aviation LLC · Ironwood, MIBuilt 1975 · S/N 421C0021 N80PMSouthbreeze Aviation LLC · Wellington, FLBuilt 1983 · S/N 425-0181 N80PVRamos Investments Lp · Montgomery, TXBuilt 1977 · S/N 414-0963 N80RSRoberson Mark E · Milton, FLBuilt 1975 · S/N 421B0895 N810BWHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0279 N811NATm Aero LLC · Riverview, FLS/N 421C-1082 N811PGH&S Aircraft LLC · Lewes, DEBuilt 1984 · S/N 421C1413 N8125FMaglaughlin Ronald D · Udall, KSFirst renewal noticeS/N 402-0231 N8129QJolly Tyler S · Grover, COS/N 414-0029 N812SRVantage Point Northwest Aviation LLC · Sheridan, WYBuilt 1979 · S/N 414A0326 N8131QClub Jet Investments LLC · Wilmington, DES/N 414-0031 N8134QPaul Morrill Excavating Inc · Newcastle, CABuilt 1969 · S/N 414-0034 N8144QOcf Air LLC · Phoenix, AZBuilt 1970 · S/N 414-0044 N8145QWestern Nebraska Community College · Scottsbluff, NES/N 414-0045 N8150QSouthern Journey LLC · South Padre Island, TXS/N 414-0050 N8151QMiller James A Md · Merino, COS/N 414-0051 N815SBN815sb LLC · Liberal, KSBuilt 1981 · S/N 425-0112 N816LHL Howard Construction Inc · Abernathy, TXS/N 421B0565 N817JPOdom Johnny C · Fredericksburg, TXBuilt 1976 · S/N 414-0850 N817LLJg Aero LLC · Clermont, FLS/N 421C0230 N8181GAirplane LLC · Coeur D Alene, IDS/N 421C0302 N818AKWhirley Robert G · Santa Rosa, CABuilt 1981 · S/N 421C1085 N818ANBank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 402C0501 N818DHCouch Fred · Fort Worth, TXS/N 421C0840 N818PLWings Aloft Inc · Eastvale, CABuilt 1981 · S/N 425-0109 N818TKInternational Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N 421C0873 N818XJays Aircraft Maintenance Inc · Costa Mesa, CAS/N 421C1021

Back to AD 2018-03-03 R1