Skip to content

Registered aircraft · 54,019

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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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.

N1388SCowboy Taxi LLC · Payson, AZBuilt 1976 · S/N 18264949 N1388UBeining Grant P · Fullerton, CABuilt 1976 · S/N 17267059 N13890Registration Pending · Commerce, GARegistration pendingBuilt 1974 · S/N 17263031 N13892Meyers Alexander C · Pittsburgh, PABuilt 1976 · S/N 17702475 N1389FBedford Aero Club Inc · Bedford, INS/N 17254884 N138FRAyotte Matthew A · South Haven, MIBuilt 1986 · S/N 17276545 N138JPChang Denny · Easton, PABuilt 1970 · S/N 17701442 N138RCBardin G W · Granville, NYBuilt 1976 · S/N 177RG0994 N138SWQualitair LLC Trustee · MichelstadtBuilt 1977 · S/N 18265569 N138WWCutler Christopher P · Whitewright, TXBuilt 1954 · S/N 26189 N13902Campbell Travis G · Starr, SCBuilt 1974 · S/N 17263035 N13905Positive Rate LLC · Rutherford, NJBuilt 1974 · S/N 17263036 N1390LGreen Rose LLC · Swartz Creek, MIBuilt 1978 · S/N 33701882 N1390YMarshall Greg J · Alexandria, VABuilt 1961 · S/N 17249090 N1391QPark Derek B · Lyons, GABuilt 1971 · S/N 15072691 N1391SWysong Charles J · Hickory, NCFirst renewal noticeBuilt 1976 · S/N 18264952 N1391UArctic Winds Inc · King Salmon, AKS/N 17267062 N13923Timoszyk James S · Wayne, MIBuilt 1974 · S/N 17263039 N1392DChalender Robert Christopher · Cocoa, FLS/N 19968 N1392QRegistered aircraftBuilt 1971 · S/N 15072692 N1392SAbc Flying Club Inc · West Mifflin, PABuilt 1976 · S/N 18264953 N1392YDoty Douglas C · The Dalles, ORBuilt 1961 · S/N 17249092 N13938Seattle Offshore Dmi Inc · Bothell, WAS/N 17263041 N13939Diessner Daniel J · New Smyrna Beach, FLBuilt 1976 · S/N 17702477 N1393EMossler Jonathan E · Edgewater, FLBuilt 1978 · S/N 17270983 N1393FBenham John D · Blanco, TXBuilt 1975 · S/N 18502840 N1393QBeitel Ronald Lee · Rochester, MNBuilt 1971 · S/N 15072693 N1393USelim Shahir P · Hollywood, FLBuilt 1976 · S/N 17267064 N1393YHall Bret C · West Plains, MOBuilt 1962 · S/N 17249093 N13941Wings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17263044 N13942Rohrer Mary · Fredericksburg, TXBuilt 1974 · S/N 17263045 N13943Tell Christopher A · Colville, WAS/N 17263046 N13944Ripp Ted · Pulaski, TNBuilt 1974 · S/N 17263047 N13946Air Capital Aviators Club · Wichita, KSBuilt 1974 · S/N 17263048 N1394FWeller Fred R · Saint Augustine, FLBuilt 1966 · S/N 17254889 N1394QDaugherty Keith C · Venus, PABuilt 1971 · S/N 15072694 N1394SGoodman Donald J · Bellingham, WABuilt 1976 · S/N 18264955 N1395EHendricks Paul · Yellville, ARBuilt 1978 · S/N 17270984 N1395SGarcia Robert W · Floresville, TXFirst renewal noticeS/N 18264956 N1395UBentley Robert H · Lockport, ILBuilt 1976 · S/N 17267066 N1395YEisele William Robert · Alt Loma, CABuilt 1961 · S/N 17249095 N1396DFlying Dutchman Aviation LLC · Richmond, TXBuilt 1951 · S/N 19972 N1396YGarrison Shannon · Pangburn, ARS/N 17249096 N1397MRichs Inc · Wilmington, DES/N 21061940 N1397SKnotty Aviation LLC · Fort Myers, FLBuilt 1976 · S/N 18264958 N1397URock Solid Aviation LLC · Lake Charles, LABuilt 1976 · S/N 17267068 N1397YMeyer Richard L · Fort Wayne, INBuilt 1961 · S/N 17249097 N1398CBennett Eric · Warsaw, INBuilt 1977 · S/N 17702720 N1398EMichael Elan · Encino, CABuilt 1978 · S/N 17270985 N1398SOff The Charts LLC · Kalispell, MTBuilt 1976 · S/N 18264959

Back to AD 87-20-03 R2