Skip to content

Registered aircraft · 81,733

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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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.

N4608WWalden Brian S · Mount Vernon, OHBuilt 1976 · S/N 13098 N46090Sentinel Services Group LLC · Brooksville, FLBuilt 1981 · S/N 15285318 N46091Pilot Instructional Center LLC · Kansas City, MOBuilt 1974 · S/N 17264176 N4609LStork 1 LLC · Green Cove Springs, FLBuilt 1980 · S/N 15284197 N4609QN4609q LLC · Opa-Locka, FLBuilt 1973 · S/N 17261724 N4609WBoling Kyle C · Oak Hill, FLS/N 13099 N460AAAlf Ix LLC · Chicago, ILBuilt 2022 · S/N 2881528 N460ACArizona Skies Aviation LLC · Scottsdale, AZBuilt 2000 · S/N 440-2000 N460EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12650 N460FLHillenbrand Sean P · Westminster, CABuilt 1971 · S/N 28-7125257 N460JBLipscomb Richard L · Bowie, TXBuilt 2001 · S/N 690-320-434 N460JCCopper River Airmotive LLC · Copper Center, AKBuilt 2006 · S/N 2343 N460LELeading Edge Flight Academy LLC · Bend, ORBuilt 2006 · S/N 4060 N460LMMassey Larry A · New Braunfels, TXBuilt 1977 · S/N 321-77 N460LZChapman Daniel W · Soldotna, AKBuilt 1983 · S/N 460 N460NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2023 · S/N 2881655 N460PHRicter Edward T · Fairbanks, AKBuilt 1988 · S/N 7493C N460RWicklund Gerald G · Liberty, MOS/N 18267786 N460SCFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 4496551 N460TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881860 N460UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020163 N460XSkyblue Aviation Cr Inc · Merritt Island, FLBuilt 1978 · S/N 28-7816581 N46100Aerflow Inc · Jersey City, NJBuilt 1968 · S/N 17257041 N46101Patel Aman · Wesley Chapel, FLBuilt 1968 · S/N 17257042 N46107Trieber Steven M · Eastport, MEBuilt 1968 · S/N 17257046 N46109Pray Aviation Inc · Augusta, KSBuilt 1968 · S/N 17257047 N4610DWolf Gary J · College Grove, TNBuilt 1997 · S/N 22062 N4610QBlaire William C · Rch Palos Vrd, CABuilt 1973 · S/N 17261725 N4610RClick Dennis R · Seattle, WABuilt 1965 · S/N 28-21359 N4610YPanama City Cycles Inc · Panama City, FLBuilt 1971 · S/N 18-8940 N4610ZGrantham Farley · Bush, LAS/N 22-8124 N46115Capri Aircraft LLC · Madison, VABuilt 1968 · S/N 17257049 N46118Epiphany Software Co · Wilmington, NCBuilt 1968 · S/N 17257051 N46119Parrish Aviation Flight Academy LLC · Southlake, TXBuilt 1968 · S/N 17257052 N4611REdwards Ruben W · Mesa, AZBuilt 1966 · S/N 28-21360 N4611WPhillips James E · Mammoth Lakes, CAS/N 13101 N4611ZRichard Waldren LLC · Newberg, ORFirst renewal noticeBuilt 1961 · S/N 22-8125 N46122Martin Gregory C Jr · Homer, AKFirst renewal noticeBuilt 1968 · S/N 17257054 N46125East Carolina Aviation LLC · Camden, NCBuilt 1968 · S/N 17257056 N46126Knight Kenneth D · Stoneville, NCBuilt 1968 · S/N 17257057 N46128Meridian Aircraft Leasing LLC · Anniston, ALBuilt 1968 · S/N 17257059 N4612DPrecision Flight Training Inc · Newberg, ORBuilt 1979 · S/N 17272315 N4612YGrasshopper Aviation LLC · Tulsa, OKBuilt 1971 · S/N 18-8933 N46130Waltzer Eric · Riverside, CABuilt 1968 · S/N 17257061 N46132N46132 Leasing LLC · Kalispell, MTBuilt 1968 · S/N 17257063 N46133Baham Daniel R · Eunice, LAS/N 17257064 N46134Training Planes LLC · Tampa, FLBuilt 1978 · S/N 15283003 N46135Mc Masters James I · Springfield, VABuilt 1978 · S/N 15283004 N46138Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15283005 N4613QSouth Seattle College · Seattle, WABuilt 1973 · S/N 17261727

Back to AD 81-18-04 R2