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.

N1646ZDmitry P Kudryn · Wasilla, AKBuilt 1962 · S/N 185-0446 N1647MAmerimed Aviation LLC · Buford, GABuilt 1975 · S/N 18264400 N1647ZSantana Barry W · Wasilla, AKBuilt 1962 · S/N 185-0447 N1648MForsberg Aviation Inc · Elk Grove, CABuilt 1975 · S/N 18264401 N1649MMitten Aero LLC · Lexington, MIS/N 18264402 N164BDRuffin Robert L Jr · Mabank, TXBuilt 2004 · S/N 18281459 N164CWMudd Joe · Tucson, AZBuilt 2004 · S/N 18281325 N164JDDominik James W · Golf, ILBuilt 1966 · S/N 18051816 N164JMWind Sand & Stars Aviation LLC · San Diego, CABuilt 1978 · S/N R18200158 N164SJFriedman Matthew · Herndon, VABuilt 1997 · S/N 18280064 N164VPConservation Aviation LLC · Washington, DCS/N U20601942 N1650CBrokaw Samuel J · South Bend, INBuilt 1953 · S/N 30350 N1650UWilson Joshua Allen · Mckinney, TXBuilt 1974 · S/N 20700250 N1650ZRobinson Christopher C · Olivet, MIBuilt 1962 · S/N 185-0450 N1651XPeters Mark E · Newport News, VABuilt 1975 · S/N 21060686 N1652XBlackbridge Holdings LLC · Helena, MTBuilt 1975 · S/N 21060687 N1653CLoveness Ghyrn E · Cave Creek, AZBuilt 1953 · S/N 30353 N1655CMardis Nicky Lee · Goddard, KSBuilt 1953 · S/N 30355 N1655XApostolou Gregory · Henderson, NVBuilt 1975 · S/N 21060690 N1656CAnderson Thomas R · Seattle, WABuilt 1953 · S/N 30356 N1656RBollenbacher Jeffery · Terre Haute, INBuilt 1978 · S/N R18200498 N1656XAnderson George E · Newnan, GABuilt 1975 · S/N 21060691 N1657CBrauchler Ben H · Hernando, MSBuilt 1953 · S/N 30357 N1657MPrecision Design Inc · Wilimington, DEBuilt 1975 · S/N 18264403 N1657REnroute Direct LLC · Woodstock, GABuilt 1978 · S/N R18200499 N1657XRowe William W · Provo, UTBuilt 1975 · S/N 21060692 N1658AApplied Trails Research LLC · Staunton, VABuilt 1978 · S/N 18266315 N1658URenfro Michael W · Bethel, AKBuilt 1974 · S/N 20700258 N165AMitchell Flying Club Inc · Lees Summit, MOBuilt 1979 · S/N 18267062 N165CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281865 N165NHExpert Aircraft Thinking & Restoration LLC · Wilmington, DEBuilt 1984 · S/N 18268382 N165WFHardin John M · Terrell, TXBuilt 1962 · S/N 210-57875 N1661MTurbo Tech Investments LLC · Montrose, COBuilt 1975 · S/N 18264406 N1661RStrong Mitchell · Batavia, NYS/N R18200502 N1664RState Of Montana · Helena, MTBuilt 1978 · S/N R18200503 N1668MRocky Mountain High Aviation LLC · Louisville, COBuilt 1975 · S/N 18264409 N1668REdwards Air Force Base Aero Club · Edwards Afb, CAFirst renewal noticeBuilt 1978 · S/N R18200505 N1668UUngalik Syndicate LLC · Unalakleet, AKBuilt 1975 · S/N 20700268 N1669Berardinelli Michael A · Meridian, IDBuilt 1955 · S/N 31946 N166DGDg Air LLC · Oakland, TNS/N 18267796 N166JBEp Aviation LLC · Wynne, ARS/N 18262300 N166VNLower Columbia River Company LLC · Longview, WABuilt 1950 · S/N 7588 N166ZUsda Forest Service Fire & Aviation · Boise, IDBuilt 1986 · S/N U20606923 N1670CAlaska Freight Services LLC · Fairbanks, AKBuilt 1953 · S/N 30370 N1670MFirebird Aviation LLC · Tempe, AZBuilt 1975 · S/N 18264410 N1672RBriggs Donald L · Santa Barbara, CABuilt 1978 · S/N R18200507 N1673RGregory John F · Emmitsburg, MDBuilt 1978 · S/N R18200508 N1674CFarwest Aviation LLC · Billings, MTBuilt 1953 · S/N 30374 N1675XNo Runways LLC · Iraan, TXBuilt 1975 · S/N 21060710 N1676RBlue Side Up LLC · Elbert, COBuilt 1978 · S/N R18200510

Back to AD 84-10-01 R1