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.

N9471CHitpas Henry R II · Beaufort, SCBuilt 1978 · S/N 28R-7837200 N9472CRhoads Timothy C · Logan, NMBuilt 1978 · S/N 28R-7803260 N9474NA-G-E Corp · Fort Pierre, SDS/N 28R-35191 N9476NScheigert Delbert F Jr · Tucson, AZBuilt 1969 · S/N 28R-35193 N9478NChadwick Aviation Services LLC · Monroe, CTBuilt 1969 · S/N 28R-35196 N9480NHernandez Luis · Surprise, AZS/N 28R-35198 N9481NKing Cindy · Purvis, MSBuilt 1969 · S/N 28R-35199 N9484NBourjeili Elias · Glendora, CABuilt 1969 · S/N 28R-35202 N9486NRahimi Navid B · Silver Spring, MDBuilt 1969 · S/N 28R-35205 N9491NWalker Mark L · Turlock, CABuilt 1969 · S/N 28R-35212 N9492NKnaust Kurt · Baldwinsville, NYBuilt 1969 · S/N 28R-35213 N9493NHigh Prairie Aviation LLC · Washington, IABuilt 1969 · S/N 28R-35214 N9495NNagel Richard A · Mequon, WIBuilt 1969 · S/N 28R-35216 N9498KDirksen Caleb A · Garner, IABuilt 1976 · S/N 28R-7635245 N9498NKoehler Scott A · Brighton, ILBuilt 1969 · S/N 28R-35219 N9499NFlight Niner Niner LLC · Charleston, SCBuilt 1969 · S/N 28R-35220 N94NARegistration Pending · Northampton, MARegistration pendingS/N 2844003 N94PMKingdom Planes LLC · Decatur, TXBuilt 1982 · S/N 28R-8218018 N94RRMaxwell Theresia · Charlotte, NCBuilt 1979 · S/N 28R-7918144 N950DSSchmitt Douglas F · Bloomsbury, NJBuilt 1978 · S/N 28R-7837167 N9539CNafziger Aviation Leasing LLC · Wittman, MDBuilt 1978 · S/N 28R-7837206 N9555KHiggins Donald Aubrey Sr · Cornelia, GAS/N 28R-7635249 N956SAAir Statler LLC · Harbor Springs, MIS/N 28R-7435054 N9594CPassino Nicholas J · Latham, NYBuilt 1978 · S/N 28R-7837209 N959ACQualitair LLC Trustee · MichelstadtBuilt 1980 · S/N 28R-8118009 N95HFEddings Samuel David · Camino, CABuilt 1973 · S/N 28R7335311 N95PGAviation Sensation LLC · Clearwater, FLBuilt 1974 · S/N 28R-7535026 N9608KPiper Arrow N9608k LLC · Ann Arbor, MIBuilt 1976 · S/N 28R-7635250 N9613CSmall James F Jr · Great Mills, MDBuilt 1978 · S/N 28R-7803269 N962MSMt San Antonio College · Walnut, CABuilt 1976 · S/N 28R-7635459 N962WWMindlin Frank August · New Haven, CTBuilt 2000 · S/N 2844022 N9634K137 Lynwood LLC · Elmira Heights, NYS/N 28R-7635251 N963WWCash Management Consulting LLC · Granite Springs, NYBuilt 2000 · S/N 2844023 N9644KLuck Aviation LLC · Glen Allen, VABuilt 1976 · S/N 28R-7635252 N9659KBell Michael J · Duck Key, FLBuilt 1976 · S/N 28R-7635254 N9676TWindy Road LLC · Vancouver, WABuilt 1977 · S/N 28R-7703065 N9686KGaasedelen Trading Co · Edina, MNBuilt 1976 · S/N 28R-7635255 N9690CWindsock Inc · Red Wing, MNBuilt 1978 · S/N 28R-7837216 N96GCSky West Aviation Inc Trustee · Albuquerque, NMS/N 28R-7703190 N9701KEmory Christopher W · Lexington Park, MDBuilt 1976 · S/N 28R-7635257 N9721CFlorida Aviation Career Training Inc · Saint Augustine, FLS/N 28R-7837218 N9722CRobbins Joseph R · Madison, ALBuilt 1978 · S/N 28R-7837219 N9724CGlobal Capital Partners LLC · Tualatin, ORBuilt 1978 · S/N 28R-7803276 N972LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 2844172 N972MWKo Hee Sun · Norwood, NJBuilt 1999 · S/N 2844019 N972QJInvictus Health LLC · Yorktown, VAFirst renewal noticeBuilt 1978 · S/N 28R7803366 N973LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 2844173 N9764KSchoff Wardell R · Hamilton, MOBuilt 1977 · S/N 28R-7837038 N9768KArrow Aviation LLC · Topeka, KSBuilt 1977 · S/N 28R-7803067 N9777MEgs Air LLC · St Thomas, VIBuilt 2004 · S/N 2844116

Back to AD 82-06-11 R1