Skip to content

Registered aircraft · 20,485

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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.

N1602MEsparraguera Maria D · Havre De Grace, MDBuilt 1975 · S/N 18264390 N1603CJackson Zachariah J · Brainerd, MNBuilt 1953 · S/N 30303 N1605CMiller Robert H · South Beloit, ILBuilt 1953 · S/N 30305 N1605MSelter Eric Jay Trustee · Agoura Hills, CABuilt 1977 · S/N 21061950 N1607CAmos Walt · Sandy, UTBuilt 1953 · S/N 30307 N1608CMiller Gerald Roy · Denver, NCBuilt 1953 · S/N 30308 N1609CBerry John C · Thunderbolt, GABuilt 1953 · S/N 30309 N1609FHeneghan Tim S · Auburn, WABuilt 1973 · S/N 18052316 N1609XHarvey P J · Midland, TXBuilt 1975 · S/N 21060645 N160PYeager Robert F · Cuyahoga Falls, OHBuilt 1962 · S/N 18254278 N1610MBreuer Lisa · Horseshoe Bend, IDBuilt 1975 · S/N 18264395 N1612CBeck Robert A · Cove, ORBuilt 1953 · S/N 30312 N1614CMaggie L Air Service LLC · Kalispell, MTS/N 30314 N1615XBvi Aviation LLC · Wilmington, DEBuilt 1975 · S/N 21060651 N1616CCleared Direct LLC · Seville, OHBuilt 1953 · S/N 30316 N1617CRetroair Restoration LLC · Big Lake, AKBuilt 1953 · S/N 30317 N161CTEddy Company Inc · Apple Valley, CABuilt 1984 · S/N 18268414 N161EWalsh David E · North Platte, NEBuilt 1956 · S/N 32692 N161VPConservation Aviation LLC · Washington, DCBuilt 1971 · S/N U20601719 N1621Diem Ronald · Myerstown, PABuilt 2025 · S/N 18283315 N1622Susanville Aviation LLC · Susanville, CAS/N 18268181 N1622CPutnal Aviation LLC · Ambrose, GABuilt 1953 · S/N 30322 N1623CCarlson Thomas G · Anchorage, AKS/N 30323 N1623MMountain Ranch Air Inc · Sioux Falls, SDS/N 18264396 N1624Going Somewhere LLC · Dover, DEBuilt 2018 · S/N 18283056 N1625UFly2k LLC · San Jose, CABuilt 1982 · S/N 21064710 N1626CLabrecque Maurice O · Anchorage, AKBuilt 1953 · S/N 30326 N1627CTerry Michael R Trustee · Bullhead City, AZBuilt 1953 · S/N 30327 N1628ZVertex Aviation LLC · Kodiak, AKBuilt 1962 · S/N 185-0428 N162BJAircraft Ownership Solutions LLC · Kokomo, INBuilt 1978 · S/N 18266440 N162CSFrielingsdorf Tim Richard · Manvel, TXBuilt 1998 · S/N 18280192 N162JSPeeler Jason Byron · Floresville, TXBuilt 1980 · S/N 18267510 N162NRBurlington Technical Center · Burlington, VTBuilt 1957 · S/N 32805 N162TCDrummond E Garrison · Parksley, VABuilt 1998 · S/N 18280164 N162VPVirunga Airwing LLC · Washington, DCS/N U20606215 N1630CRjd Flyers LLC · Mount Juliet, TNBuilt 1953 · S/N 30330 N1632CWarren Mark W · Arlington, WABuilt 1953 · S/N 30332 N1632MD&J Training Planes LLC · Logan, UTBuilt 1975 · S/N 18264398 N1633MHill David A · North Ridgeville, OHBuilt 1975 · S/N 18264399 N1633XRhodes Donald P · Fort Worth, TXBuilt 1975 · S/N 21060669 N1634XBadwater Ranch Inc · Lysite, WYBuilt 1975 · S/N 21060670 N1636XMonke Farm & Cattle Co · Nickerson, NEBuilt 1975 · S/N 21060672 N1637CAshby Clark S · Pleasant Grove, UTBuilt 1953 · S/N 30337 N163CLJust Saying Construction LLC · Merritt Island, FLS/N 21062122 N163CTRenson Travel LLC · San Antonio, TXBuilt 2016 · S/N 18282390 N163HJ&L Asset Holdings LLC · Biloxi, MSBuilt 1957 · S/N 34049 N163JBBender W Jeffrey · Ocala, FLBuilt 2000 · S/N 18280715 N163RHHollis Richard H · Auburn, MES/N 18051307 N1644CAero 290 LLC · Burlington, WIBuilt 1953 · S/N 30344 N1645CRoach Aviation LLC · Longview, TXBuilt 1953 · S/N 30345

Back to AD 84-10-01 R1