Skip to content

Registered aircraft · 40,394

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:79-10-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2') 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:79-10-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2')
  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:79-10-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2')
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.

N8906VLewis David A · Broadalbin, NYBuilt 1974 · S/N 17264263 N8907YKiehl Dwane K · Winnett, MTBuilt 1973 · S/N 18-7409034 N8909Registration Pending · Stockton, CARegistration pendingBuilt 1967 · S/N 2823008 N8909DWellborn Michael A · Kenai, AKBuilt 1958 · S/N 22-6064 N8909JJenson Adam D · Duluth, MNBuilt 1965 · S/N 28-2890 N890BLSylvester John A · Hereford, AZBuilt 1990 · S/N 502 N890BVJefferies James A Trustee · Peck, KSBuilt 1973 · S/N 28-7305215 N8910DArmes John W · Elkhorn, WIS/N 22-6066 N8911DPunt Eric · Wasilla, AKBuilt 1958 · S/N 22-6067 N8911VHorizon Dreams LLC · Homer, GABuilt 1974 · S/N 17264268 N8912DParris Michael D · Rockport, TXFirst renewal noticeS/N 22-6068 N8912JSoar With Sophia LLC · South Lyon, MIBuilt 1965 · S/N 28-2894 N8912VRoper Jeff A · Corralitos, CABuilt 1974 · S/N 17264269 N8913DBrick H Paul · Pomerene, AZBuilt 1958 · S/N 22-6069 N8913VI'Ll Fly Away LLC · Florence, SCBuilt 1974 · S/N 17264270 N8914DPieper Michael D · Chandler, OKBuilt 1958 · S/N 22-6097 N8914JVesper Aviation LLC · Las Vegas, NVBuilt 1965 · S/N 28-2929 N8916VTaylor William W Jr · Hudson Oaks, TXBuilt 1974 · S/N 17264273 N8916YMyers Randall · Parshall, NDBuilt 1973 · S/N 18-7409035 N8917JI Was Inverted LLC · Fort Myers, FLS/N 28-2932 N8918DPapalote Ranches LLC · Missoula, MTBuilt 1958 · S/N 22-6075 N8918YFerucci Paul G · Anchorage, AKBuilt 1973 · S/N 18-7409036 N8919DLuallin Randy D · Hot Springs, SDBuilt 1958 · S/N 22-6076 N8919JKelly Kevin R · Ormond Beach, FLBuilt 1965 · S/N 28-2935 N8919VChristiansen John · Vicksburg, MIBuilt 1974 · S/N 17264276 N891GPHancock Aircraft Sales LLC · Baton Rouge, LABuilt 1967 · S/N 28-23847 N8920DReese Larry H · Raytown, MOS/N 22-6077 N8920JSargent Timothy E · Pickerington, OHBuilt 1965 · S/N 28-2937 N8921RPotters Aviation LLC · Haskell, OKBuilt 1960 · S/N 7GCA-168 N8921VN2827n LLC · Pembroke Pines, FLS/N 17264278 N8922Culver Marc D · Anchorage, AKBuilt 1973 · S/N 493-73 N8922DHassell Clark R · Ketchikan, AKBuilt 1958 · S/N 22-6079 N8922JTowner Jeffery D · Rose Hill, KSBuilt 1965 · S/N 28-2939 N8922VTampa Bay Aviation Inc · Clearwater, FLBuilt 1974 · S/N 17264279 N8923Brockway Troy D · Salina, KSBuilt 1973 · S/N 481-73 N8923DWood Rhonda R · Livermore, CABuilt 1958 · S/N 22-6080 N8923JVenture West LLC · Mesa, AZBuilt 1965 · S/N 28-2940 N8924DHickey Aero Services LLC · White Hills, AZS/N 22-6081 N8924VDupree Johnny · Crossett, ARBuilt 1974 · S/N 17264281 N8926DPlanes & Things Inc · Collinsville, OKBuilt 1958 · S/N 22-6083 N8926JGreene Ronald F · Mc Alpin, FLBuilt 1965 · S/N 28-2944 N8926VCareer Flight Training And Aircraft Rental LLC · Naples, FLBuilt 1974 · S/N 17264283 N8927JTipton Thomas G · Walnut Grove, MOS/N 28-2945 N8927VTropical Aviation LLC · Gulf Shores, ALBuilt 1974 · S/N 17264284 N8928Anding Jay B · Bryan, TXBuilt 1973 · S/N 483-73 N8928JHaybron David M · Sewickley, PABuilt 1965 · S/N 28-2946 N8929Cavanagh James B · Litchfield Park, AZBuilt 1973 · S/N 255-73 N8929JRice Spencer F · Portland, ORBuilt 1965 · S/N 28-2947 N8929LPeters Nicholas J · Eagle River, AKBuilt 1974 · S/N 18-7409127 N892PTTims Duane R · Hemet, CABuilt 2012 · S/N 70567

Back to AD 79-10-03 R2