Skip to content

Registered aircraft · 5,075

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-19-03-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-19-03-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-19-03-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-19-03-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-19-03-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-19-03-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.

N811CBRfw Construction Group LLC · Dyersburg, TNBuilt 1974 · S/N 31-7512001 N811PJObrien Neal J · Milton, GABuilt 1969 · S/N 3051 N8124YMatthews Grover C · Hardinsburg, KYBuilt 1966 · S/N 27-3237 N8125DBas Part Sales LLC · Greeley, COBuilt 1979 · S/N 32R-8029014 N8126PCsm Holding LLC · Boscobel, WIBuilt 1963 · S/N 24-3379 N8127ZCrawford Oil Co Inc · Hayti, MOBuilt 1979 · S/N 32R-8029017 N8128BMcguinnis Joseph G · Scottsdale, AZS/N 32R-8029018 N812DKTranscendent Enterprises Inc DBA · Pine Grove, CABuilt 2005 · S/N 3257397 N812MFj Aviation LLC · Texarkana, TXBuilt 2000 · S/N 32-57162 N812MBOeth Laurence B III · Midland, TXBuilt 1997 · S/N 4636111 N812TBTwin Aviation LLC · Coushatta, LABuilt 1981 · S/N 31-8152113 N8137VAeolus Aviation LLC · River Hills, WIBuilt 1980 · S/N 32R-8029003 N8138PFrank Castillo Dds Inc · San Jose, CABuilt 1963 · S/N 24-3392 N81436P&C Construction Inc · Chattanooga, TNBuilt 1979 · S/N 32R-8029045 N8144GDistant Horizons LLC · Park City, UTBuilt 1979 · S/N 32R-8029047 N8148YJustison David L · Hillsboro, ILBuilt 1982 · S/N 32R-8329005 N814CVJam Zoom Yayos LLC · Manheim, PABuilt 2002 · S/N 2137 N814FARivinius Sam · Danville, CABuilt 2003 · S/N T18208214 N81573Jsham LLC · Sheridan, WYS/N 32-8024004 N8158BRegistration Pending · Springfield, MORegistration pendingS/N 32R-8229038 N8158YRobert Lea Investments LLC · Molalla, ORBuilt 1980 · S/N 32-8024006 N8159SGaither David G Executor · Houston, TXS/N 32R-8029059 N8159YRaven Aviation LLC · Murrayville, GABuilt 1980 · S/N 32R-8029060 N815TAS3 Air Aviation LLC · Henderson, NVBuilt 1976 · S/N 32R-7680356 N8165JLloyd J Cleaver D O LLC · Kirksville, MOBuilt 1980 · S/N 32-8024010 N8165RLord David A DBA · Mackay, IDFirst renewal noticeBuilt 1980 · S/N 32R-8029063 N8167DBurch Robert S · Tyler, TXBuilt 1980 · S/N 32R-8029049 N8169ZHarper Hugh Holdings LLC · Alvarado, TXBuilt 1980 · S/N 32-8024012 N816ARCustom Curb Inc · Ventura, CABuilt 2005 · S/N T18208451 N816GHolland Travel Air LLC · Holmen, WIBuilt 1964 · S/N TD-562 N816YPB&D Air Solutions LLC · Austin, TXBuilt 1978 · S/N 32R-7885267 N8170SSkywagons.Com LLC · Placerville, CAS/N 32R-8029067 N8171WAnderson Christopher J · Ogden, UTBuilt 1965 · S/N 28-2291 N8172PWison Keene · Abbeville, GABuilt 1981 · S/N 32R-8129028 N8173PLao Investments LLC · Meeker, COBuilt 1980 · S/N 32-8024015 N8177YElite Approach LLC · Chesterfield, MOBuilt 1982 · S/N 32R-8229042 N817TRRobinson Trent · Havana, FLBuilt 2000 · S/N 3257132 N8180DBobert Bunny LLC · Wilmington, DEBuilt 1980 · S/N 32R-8029075 N8180FTag International Corporation Inc · Sheridan, WYBuilt 1980 · S/N 32R-8029076 N8185CKirkland Kerry G · Spring, TXBuilt 1975 · S/N 32-7640053 N8185WAlaska Media LLC · Anchorage, AKBuilt 1980 · S/N 328024017 N8185YCarter Gregory A · Edmonds, WABuilt 1980 · S/N 32-8024018 N8186FN8186f Inc · Danville, INBuilt 1976 · S/N 32R-7780088 N8187PKlein Dale A · Mandan, NDBuilt 1963 · S/N 24-3443 N8188MSmith Jeffrey E · Dunedin, FLBuilt 1982 · S/N 32R-8229043 N8188TPiper Aircraft Inc · Vero Beach, FLBuilt 1980 · S/N 32R-8029081 N818AHChandler Jerome P · Redondo Beach, CABuilt 1973 · S/N 32-7340126 N818CCFlyit LLC · Camas, WAS/N 27-2977 N818DUPrescott John E Jr · Tempe, AZBuilt 2004 · S/N T18208313 N818TECentral Airlines Inc · Leawood, KSBuilt 1960 · S/N 500B-995-26

Back to AD 84-19-03 R1