Skip to content

Registered aircraft · 20,486

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.

N145PPainter Bryan J · Renton, WABuilt 1963 · S/N 205-0332 N145PLState Of Alaska · Anchorage, AKBuilt 1981 · S/N U20606141 N145VCurrier Susan · Greenvlle Jct, MEBuilt 1948 · S/N 7135 N1462SRiverside Aviation LLC · Oakland, IABuilt 1976 · S/N 18265009 N1464SRauch Andrew J · Timnath, COBuilt 1976 · S/N 18265011 N1465MBig Mountain Construction LLC · La Grande, ORBuilt 1969 · S/N U20601465 N1466MTabor Shayne · Renville, MNBuilt 1970 · S/N U20601466 N1466SCombs Brent L · Dallas, SDBuilt 1976 · S/N 18265013 N1468MArctic Barnabas Ministries · Kenai, AKBuilt 1970 · S/N U20601468 N1469SS & J Farms · Floydada, TXBuilt 1976 · S/N 18265016 N146EN146e LLC · Thomasville, GABuilt 1982 · S/N 18268292 N146FAcrehood Air LLC · St Augustine, FLBuilt 2004 · S/N 18281437 N146FCUsda Forest Service Fepp · Malvern, ARBuilt 1966 · S/N P206-0247 N146NEAngle Mark W · Lake Orion, MIBuilt 1998 · S/N 18280221 N146WHAmick Ralph O · Hatteras, NCS/N 18280304 N146YBayer Peter D · Naperville, ILBuilt 1955 · S/N 32098 N1473M182p LLC · Oklahoma City, OKBuilt 1975 · S/N 18264340 N1473SBattin Robert C · Cartersville, GABuilt 1976 · S/N 18265020 N1475SMurdoch-Haig Alexandra · Kailua, HIBuilt 1976 · S/N 18265022 N1476SBk1 Farms LLC · Rock Port, MOBuilt 1976 · S/N 18265023 N1478MWestern Wind Aviation LLC · Suisun City, CABuilt 1975 · S/N 18264343 N147HBCooley Timothy · Gilbert, AZBuilt 2017 · S/N 18283011 N147KLarson David W · New Iberia, LABuilt 1975 · S/N 18264068 N147MCSoloman Lynell J · Forks, WABuilt 1976 · S/N 18265026 N147SHDe Camara Robert Michael · Boone, NCS/N 185-0960 N147TXTexas Department Of Transportation · Austin, TXBuilt 1979 · S/N U20604987 N1480SAll In One Aviation LLC · Burleson, TXBuilt 1976 · S/N 18265027 N1481STraylor Margie · Cave Creek, AZBuilt 1976 · S/N 18265028 N1483L83l Ventures LLC · San Carlos, CABuilt 2007 · S/N 18281960 N1483MMaster Aviation LLC · Augusta, GAS/N 18264348 N1484SRoland Michael T · Gualala, CABuilt 1976 · S/N 18265031 N1485SMitchell Daniel P · Marseilles, ILBuilt 1976 · S/N 18265032 N1486MBrewer Donald S · Paragould, ARBuilt 1975 · S/N 18264349 N1486SBurdine Aviation Inc · Glidden, IABuilt 1976 · S/N 18265033 N14872Blumenthal James R · Kingman, AZBuilt 1973 · S/N U20602144 N1487SSkovira Michael D · Scottdale, PABuilt 1976 · S/N 18265034 N1489LBusiness Mens Flying Club Inc · Naperville, ILBuilt 2007 · S/N 18281901 N1489MBrinker Corp Inc · Glen Elder, KSBuilt 1975 · S/N 18264350 N1489SBender Roger J · Overgaard, AZBuilt 1976 · S/N 18265036 N148GMorrill William I · Kerrville, TXBuilt 1979 · S/N 18267097 N148JBBell Jason W · Flower Mound, TXBuilt 1979 · S/N 18266827 N148SMSarasota Westwind Flyers Inc · Sarasota, FLS/N 18280040 N148TXRegistration Pending · Austin, TXRegistration pendingBuilt 1979 · S/N 18267500 N1490SEfna LLC · Wichita, KSBuilt 1976 · S/N 18265037 N1492SBurr John R · Salem, VABuilt 1976 · S/N 18265039 N1492UD & S Aviation LLC · Spring, TXBuilt 2007 · S/N 18281962 N1493MOverly Terrence L · Tok, AKS/N U20601493 N1493RChaffin Alex · Fayetteville, ARBuilt 2005 · S/N 18281694 N1494CFour C'S Equipment Leasing LLC · Fresno, CABuilt 1978 · S/N 21063065 N1494S1494 Sierra Inc · Waynesville, OHBuilt 1976 · S/N 18265041

Back to AD 84-10-01 R1