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.

N863CPNet Quest Management Services LLC · Winter Haven, FLBuilt 1968 · S/N 421-0117 N866KABad Aire LLC · Aledo, TXS/N 421C1255 N866PMBluview Management LLC · Avon Park, FLS/N 421C0651 N86AWMohave County Sheriff'S Office · Kingman, AZBuilt 1978 · S/N 414A0040 N86PDTanric Aviation LLC · Tuscola, TXBuilt 1982 · S/N 414A0837 N86VSPlotkin Aviation LLC · Boca Raton, FLS/N 414-0955 N870VLCaribbean Flyers LLC · San Juan, PRBuilt 1981 · S/N 402C0616 N871VLZee Enterprise Inc · Chicago, ILBuilt 1980 · S/N 402C0290 N87386Golden Eagle Flyers Inc · Cheyenne, WYS/N 421C0168 N87541Chadbourne Daniel I Jr · Anchorage, AKS/N 421C0007 N87561Forest Aire LLC · Flagstaff, AZBuilt 1975 · S/N 421C0017 N877JBOg Flights LLC · Dover, DEBuilt 1980 · S/N 421C0877 N8789BBearcat Aviation LLC · Joplin, MOBuilt 1980 · S/N 414A0605 N878DMFly North 421 LLC · Helena, MTBuilt 1977 · S/N 421C-0413 N878SPC-140 Co LLC · Milton, FLBuilt 1974 · S/N 421B0634 N87CGPro Aire Cargo & Consulting Co Inc · Oshkosh, WIBuilt 1975 · S/N 402B0883 N87GKAlpha Zulu Aviation LLC · Spring, TXS/N 421C0131 N87MKWind River Aviation LLC · Lawton, OKBuilt 1974 · S/N 421B0808 N87PPAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1976 · S/N 421C0206 N880AMj Aviation LLC · Denham Springs, LABuilt 1973 · S/N 414-0397 N880JSDodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N 421C-0489 N881JPCowboy Aviation LLC · Amarillo, TXBuilt 1981 · S/N 425-0139 N881TJBarron Eddie T · Amarillo, TXBuilt 1972 · S/N 414-0259 N882BCTechnology Aviation Services LLC · Covington, GABuilt 1973 · S/N 414-0470 N884LPBecton Aviation LLC · Lubbock, TXS/N 421C0102 N8851KJac Leasing LLC · Fort Myers, FLBuilt 1979 · S/N 414A0239 N88537Gink2 LLC · Elkhorn, NEBuilt 1978 · S/N 421C0514 N8853K8853k LLC · New Bedford, MABuilt 1979 · S/N 414A0240 N88584Dallas Aero & Sales LLC · Poplar, MTBuilt 1979 · S/N 421C0642 N88604Trade Winds Aviation Holdings LLC · Lewes, DEBuilt 1978 · S/N 421C0604 N88606N88606 LLC · Ely, IAS/N 421C0649 N88646Eagle Air LLC · Garden Ridge, TXS/N 421C0630 N888EDGolden Eagle Express LLC · Dodge City, KSFirst renewal noticeBuilt 1973 · S/N 421B-0421 N888HCGolden Eagle 888hc LLC · Durham, CABuilt 1975 · S/N 421B0821 N888JSElite Aviation Inc · San Jose, CABuilt 1984 · S/N 425-0215 N888VVAbaco Xpress LLC · West Palm Beach, FLBuilt 1973 · S/N 421B0550 N88PEFirst Winds LLC · Norfolk, NES/N 421C0851 N890CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1978 · S/N 402C0006 N898EPMarcy Michael S · Farmington, NMBuilt 1973 · S/N 421B0429 N89ADClairmont Holdings Vi LLC · St Thomas, VIS/N 402C0115 N8AVOtis Air Service Inc · Wichita, KSBuilt 1974 · S/N 421B0663 N8BLPro One Janitorial Inc · Chicken, AKBuilt 1970 · S/N 414-0098 N8FBRichland Aviation Inc · Sidney, MTBuilt 1978 · S/N 402B1372 N8GALambeth Air LLC · Sitka, AKS/N 421C0842 N8HMMetco Builders LLC · Edmond, OKS/N 414-0620 N8HTServicetec LLC · Kalamazoo, MIBuilt 1978 · S/N 421C0618 N8WBSmartin Enterprises LLC · Clackamas, ORBuilt 1974 · S/N 421B0594 N900CBHnl Group LLC · Minnetonka, MNS/N 421C0837 N900SHShadowline Aviation LLC · Wilmington, DEBuilt 1979 · S/N 414A0460 N902BAEcho Charlie LLC · Manvel, NDBuilt 1979 · S/N 414A-0324

Back to AD 2018-03-03 R1