Skip to content

Registered aircraft · 40,472

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

N4037EMathews Brett G · Platte City, MOS/N 18-7809043 N4037MJensen Mitchell D · Coeur D Alene, IDBuilt 1947 · S/N 12-2920 N4037PLivernois Douglas H · Melrose, FLBuilt 2002 · S/N 465 N4038MAlyeska Helicopters LLC · Girdwood, AKBuilt 1990 · S/N 1571M N4038ZLutz Matthew S · Lewistown, MTBuilt 1963 · S/N 18-7999 N40398Emerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1990 · S/N 1590 N4039PPetersen Clayton L · Albert Lea, MNBuilt 1958 · S/N 23-1516 N4039ZMeeker Airport Inc · Meeker, COBuilt 1963 · S/N 18-8000 N403ATNew Horizons Aviation Inc · Goshen, INBuilt 2005 · S/N 40.FC004 N403BCSmith Kenneth W · Marble Falls, ARBuilt 1990 · S/N 1539 N403CPGreenblatt Steven · Macon, GABuilt 2004 · S/N 3607 N403DTTimms Douglass D · Gouldsboro, MEBuilt 1991 · S/N DT-001 N403JREllman Brett M · Cardiff By The Sea, CABuilt 1977 · S/N AA5B0441 N403RCSalt Lake Community College · Salt Lake City, UTBuilt 2000 · S/N 819 N403WDThomas Spencer S · New Castle, COBuilt 2003 · S/N 641 N4040ZAcme Cub Training Inc · Anchorage, AKBuilt 1963 · S/N 18-8001 N4041EBurns Charles R · Huntsville, ALS/N 18-7809048 N4041SDuplantis Nolan W II · Saint Martinville, LABuilt 1990 · S/N 1584 N4043EL C Hanson Co · Helena, MTBuilt 1977 · S/N 18-7809049 N4044DParker Helicopter LLC · Watsonville, CABuilt 1990 · S/N 1619 N4044GFlyrs Field · Anchorage, AKS/N 18-5614 N4044MRed Baron LLC · Kenai, AKBuilt 1947 · S/N 12-2927 N4044NLundquist Matthew Michael · Navarre, FLBuilt 1968 · S/N 680164 N4044ZHainline David O · Poway, CABuilt 1962 · S/N 18-8005 N40451Gallego Javier · Diamond Bar, CABuilt 1977 · S/N 28-7816015 N4045NPrivate Flights Inc · Harleysville, PABuilt 1968 · S/N 680025 N4045ZEastman Gregory L · Pueblo, COBuilt 1963 · S/N 18-8007 N4046AN7047x-R22 LLC · Wilmington, DEBuilt 1991 · S/N 1676 N4046PMeyer Edward E · Bolingbrook, ILBuilt 1958 · S/N 23-1523 N4046ZSprik Robert Jay · Hamilton, MIBuilt 1963 · S/N 18-8009 N4047ERegistration Pending · Somers, MTRegistration pendingBuilt 1977 · S/N 18-7809046 N4047XHarms Timothy W · Whittier, NCBuilt 1971 · S/N 5147 N4047ZGrunwaldt Peter J · Anchorage, AKBuilt 1963 · S/N 18-8011 N4048XMoorhead Equipment LLC · Belton, SCBuilt 1969 · S/N 5101 N404BHRegistered aircraftBuilt 2024 · S/N 2C-3C/4C-1574C N404DSDelaware State Universtiy · Dover, DEBuilt 1976 · S/N 28-7615141 N404MHCall One Inc · Clarinda, IABuilt 2018 · S/N 75-10615 N404RBMyrehn Bruce D · Carmel, INBuilt 1972 · S/N AA5-0101 N404SWWood Roger W · Sale Creek, TNBuilt 1968 · S/N 17256702 N40506Dingler Larry G · Langtry, TXS/N 1753 N4050GSpellbound Inc · White Bear Lake, MNBuilt 1991 · S/N 1776 N4050NCrawford Reagan Matthew · Lumberton, TXBuilt 1968 · S/N 680026 N4051PEagle 64 LLC · Stuart, FLBuilt 1958 · S/N 23-1528 N40520Goodman Larry D Trustee · Prineville, ORBuilt 1975 · S/N 18-7509121 N40523Gossett Owen L · Central Point, ORBuilt 1975 · S/N 18-7509123 N4052FG&M Aircraft Inc · Wheat Ridge, COBuilt 1976 · S/N 28-7790002 N4052VBorror Eric F · Gerber, CABuilt 1956 · S/N 18-5218 N4052ZMetro Service Air · Fairbanks, AKBuilt 1963 · S/N 18-8054 N4053ZSpohnholz Randy K · Anchorage, AKBuilt 1963 · S/N 18-8056 N40549Agnew Mark W · Wasilla, AKBuilt 1969 · S/N 18-8865

Back to AD 80-04-03 R2