Skip to content

Registered aircraft · 5,443

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:2016-07-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-07-21') 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:2016-07-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-07-21')
  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:2016-07-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-07-21')
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.

N4315YThree Wing Flight School LLC · Stratford, CTBuilt 1983 · S/N 28-8390089 N43160Dodson International Parts Inc · Rantoul, KSBuilt 1983 · S/N 28-8390090 N43171Flight Leasing Corp · Wilmington, DEBuilt 1983 · S/N 28-8490003 N4317BParis Air Inc · Vero Beach, FLBuilt 1983 · S/N 28-8416001 N4317DParis Air Inc · Vero Beach, FLBuilt 1983 · S/N 28-8416002 N4317GCendejas Agustin · Chino, CAFirst renewal noticeBuilt 1983 · S/N 28-8416003 N4317TSpanku LLC · Bay Shore, NYBuilt 1983 · S/N 28-8490002 N43186Aerolina Inc · Hendersonville, NCBuilt 1983 · S/N 28-8416008 N43187Frederick Aero Club Inc · Wilmington, DEBuilt 1983 · S/N 28-8490006 N4318BFaith Flyers Inc · Wellington, FLBuilt 1983 · S/N 28-8490004 N4318ZDodson International Parts Inc · Rantoul, KSBuilt 1983 · S/N 28-8416007 N4319DPumphrey Anthony D Sr · Little Rock, ARBuilt 1983 · S/N 28-8490007 N4319XEagle Eye Aerial Imaging LLC · Chagrin Falls, OHBuilt 1975 · S/N 28-7690002 N4319YRock Solid Aviation LLC · Lake Charles, LABuilt 1983 · S/N 28-8490010 N431PAGharazeddine Raja N · Kaplan, LABuilt 2001 · S/N 2844048 N431RMPierzchalski Aidan K · Stevenson Ranch, CABuilt 2004 · S/N 2843600 N4320YLochner Thomas H Trustee · Saratoga Springs, NYS/N 28-8416014 N4322XManitowoc Flyers Corp · Manitowoc, WIBuilt 1975 · S/N 28-7690015 N4323XRegistered aircraftBuilt 1975 · S/N 28-7690016 N4325UMetro Aircraft Co · Bloomington, MNBuilt 1983 · S/N 28-8416016 N4325VArcher Assoc LLC · Ashburn, VABuilt 1983 · S/N 28-8416017 N4326LN4326l LLC · Senoia, GABuilt 1983 · S/N 28-8490015 N4326NLikakis John M · Bennington, VTBuilt 1983 · S/N 28-8490017 N4328NTalker Albert · Stroudsburg, PABuilt 1983 · S/N 28-8416020 N4329MByrne Matthew A · West Allis, WIBuilt 1983 · S/N 28-8490021 N4329PDunn Danvil L · East Meadow, NYBuilt 1983 · S/N 28-8490022 N432HPFuehrer Wyatt R · Coatesville, INBuilt 1977 · S/N 28-7790547 N432WWMiller Kris K · Cary, NCFirst renewal noticeBuilt 1982 · S/N 28-8390009 N4330DHildebrand David S · Albuquerque, NMBuilt 1983 · S/N 28-8490026 N43314Gardners Guns & Mfg LLC · Elk City, OKBuilt 1984 · S/N 28-8490029 N4331MNieves Osvaldo Colon · San Juan, PRS/N 28-8416028 N4331PWilson Cecil · Lithonia, GABuilt 1983 · S/N 28-8416029 N4332LRubman Tracy L · Shelburne, VTBuilt 1983 · S/N 28-8416031 N4332NThree Wing Flight School LLC · Stratford, CTBuilt 1983 · S/N 28-8416034 N4333AAir-Mods Flight Academy Inc · Robbinsville, NJBuilt 1983 · S/N 28-8416037 N4333BLand & Leave LLC · Helena, MTBuilt 1983 · S/N 28-8416038 N4333CSmart 02 LLC · Kissimmee, FLBuilt 1983 · S/N 28-8416039 N4334BRed Five Air LLC · Stuart, FLBuilt 1984 · S/N 28-8490036 N4334V305 Aviation Group Inc · Miami, FLBuilt 1984 · S/N 28-8490039 N4334XOxford Flying Club Inc · Oxford, CTBuilt 1984 · S/N 28-8490040 N4335DSparrowhawk Aviation LLC · Hollister, CABuilt 1984 · S/N 28-8490043 N4335KDodge Colleen Marie · Lake Geneva, WIBuilt 1984 · S/N 28-8490044 N4337FEarly Bird Aviation LLC · Phoenix, AZBuilt 1976 · S/N 28-7790016 N4337VThunderbird Aircraft Co · Bloomington, MNBuilt 1984 · S/N 28-8416045 N4338FSzmagala Taras G Jr · Bentleyville, OHBuilt 1976 · S/N 28-7790017 N4338MAndrews University · Berrien Springs, MIS/N 28-8490048 N4338NMavity Michael D · Phoenix, AZBuilt 1984 · S/N 28-8490049 N4338PTroy Oakland Pilots Flying Club Inc · Troy, MIBuilt 1984 · S/N 28-8490050 N4338VFlying Mermaid LLC · Aiea, HIBuilt 1984 · S/N 28-8490052 N433MASkywest Leasing Inc · St George, UTBuilt 2000 · S/N 28-43362

Back to AD 2016-07-21