Skip to content

Registered aircraft · 2,376

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:82-06-11-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:82-06-11-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:82-06-11-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:82-06-11-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:82-06-11-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:82-06-11-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.

N8790EFenty Brandon · Normandy, TNBuilt 1976 · S/N 28R-7635214 N8798EFuller Glenn C · Santa Paula, CAS/N 28R-7635215 N87KGCherokee From Sebring LLC · North Brunswick, NJBuilt 1969 · S/N 28R-35043 N8819ETransition Aviation LLC · Hummelstown, PABuilt 1976 · S/N 28R-7635209 N8824ECornelius John A · Fort Worth, TXBuilt 1976 · S/N 28R-7635216 N8828CHogan Dennis E · South Hadley, MABuilt 1976 · S/N 28R-7635183 N883ACPlane Fun Inc Tr Trustee · Snellville, GABuilt 1975 · S/N 28R-7535156 N8842SMcdowell Karen · Dunedin, FLS/N 2837032 N8852CWobken Mark E · Orange, CABuilt 1976 · S/N 28R-7635184 N888RSAero Adair LLC · Valparaiso, INBuilt 1978 · S/N 28R-7803347 N888TCSilva Daniel J · Grass Valley, CABuilt 1977 · S/N 28R-7703103 N8899WQualitair LLC Trustee · MichelstadtBuilt 1977 · S/N 28R-7803046 N889TWUniversal Aviators Academy Inc · El Monte, CABuilt 1989 · S/N 2837023 N88RLLarson Kris K · Fullerton, CABuilt 1977 · S/N 28R-7703240 N8907FHughes Michael Anthony · Meridian, IDBuilt 1977 · S/N 28R-7703007 N8949CMorgan Aviation LLC · Greensboro, NCBuilt 1976 · S/N 28R-7635186 N897ALJansky Sand & Gravel Inc · Hallettsville, TXBuilt 1973 · S/N 28R-7335331 N897ECMatacia Thomas Eugene · Evergreen, NCBuilt 1969 · S/N 28R-35376 N899DWValiair Lc Trustee · Casper, WYBuilt 1984 · S/N 28R-8431011 N89HHStrissel Christopher A · Hilton Head Island, SCBuilt 1971 · S/N 28R-7135225 N89SPSky'S The Limit Flying Club Inc · Findlay, OHBuilt 1976 · S/N 28R-7635218 N8FNValiair Ltd Co Trustee · Casper, WYBuilt 1978 · S/N 28R-7837272 N8HNSol Property Group LLC · Rosenberg, TXBuilt 1975 · S/N 28R-7535277 N9011CParios Vasilios · Northfield, MAS/N 28R-7803243 N9012KDerbyshire William · Davie, FLBuilt 1977 · S/N 28R-7803057 N901BBVisual Group Inc · Tampa, FLBuilt 1974 · S/N 28R-7435256 N9022KRyczek Walter Alan · Huntersville, NCBuilt 1977 · S/N 28R-7803059 N9050KFender Jason · Jacksonville, ARBuilt 1977 · S/N 28R-7803060 N9051VWhite Air Ltd · Dover, DEBuilt 1977 · S/N 28R-7703334 N906KEDaniel Tayja · Brooklyn, NYS/N 28R-35631 N9091YCsa Investments LLC · Wayne, PABuilt 1969 · S/N 28R-35197 N9099KWallace Jacob M · Central Point, ORBuilt 1977 · S/N 28R-7837028 N90FEPasley Michael Cole · Niceville, FLBuilt 1969 · S/N 28R-35121 N90MHMooers Michael T · Hagerstown, MDBuilt 1976 · S/N 28R-7635158 N9102KM & T Aircraft LLC · North Canton, OHBuilt 1977 · S/N 28R-7837029 N910GSRobinson Nicholas Anthony · Westborough, MABuilt 1976 · S/N 28R-7635029 N9111KWdiaz Design Inc · Sunny Isles Beach, FLBuilt 1976 · S/N 28R-7635221 N911PSBittner Gregory L · Greensburg, PAS/N 28R-7435279 N913FLL B Rocket Corp · Attleboro, MABuilt 1969 · S/N 28R-35128 N9145MValenzuela Anthony R · Glendale, AZBuilt 1985 · S/N 28R-8531014 N9145NKelly Howard Vincent · Chicago, ILBuilt 1988 · S/N 2831038 N9159KRoss Andrew · Yamhill, ORBuilt 1976 · S/N 28R-7635223 N9175ZMoeckel John H · North Venice, FLBuilt 1989 · S/N 2803003 N9180DSan Souci Holdings LLC · Reisterstown, MDS/N 2837014 N9180HPiper Aircraft Inc · Vero Beach, FLS/N 2837015 N9183WAerolina Inc · Hendersonville, NCBuilt 1989 · S/N 2837024 N9201KGadamic LLC · Fresno, CABuilt 1976 · S/N 28R-7635224 N9203KJoseph L Catania Dvm Pc · Alturas, CABuilt 1976 · S/N 28R-7635225 N920DMCain Financial Inc · Fresno, CABuilt 1982 · S/N 28R-8231047 N9236CRudloff Uwe K · Lake Village, INBuilt 1978 · S/N 28R-7837181

Back to AD 82-06-11 R1