Skip to content

Registered aircraft · 8,921

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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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.

N2519PDayton Dean W · Marysville, OHBuilt 1955 · S/N 22-2881 N251ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496047 N251EARegistered aircraftBuilt 1969 · S/N 27-4238 N2522APierce Stephan L · Graham, TXBuilt 1953 · S/N 22-830 N2523AChadwick Harold T · Ottsville, PABuilt 1952 · S/N 22-829 N2523PHarris Jason C A · Unalakleet, AKS/N 22-2885 N2526ABamak Corp · Eagle River, AKBuilt 1956 · S/N 22-833 N2527PSprenger Michael D · Juneau, AKBuilt 1955 · S/N 22-2890 N2528AEhrhart Philip J · Narvon, PABuilt 1952 · S/N 22-836 N2532PRiley Mitchell C · Seattle, WABuilt 1955 · S/N 22-2895 N2534PPearson Vincent N · Broken Bow, NES/N 22-2897 N2536EEarle James K · Argonia, KSBuilt 1959 · S/N 22-6816 N253AMiller Christopher T · Newnan, GABuilt 1956 · S/N 23-806 N253ATAirlines Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496057 N2540ASlaton James E · Minot Afb, NDS/N 22-837 N2540PReed Michael D · Parsons, KSBuilt 1955 · S/N 22-2903 N2544PCoonfield Russell Adam · Fayetteville, ARBuilt 1955 · S/N 22-2907 N2545CDot Aviation LLC · Wilmington, DEBuilt 2012 · S/N 4496324 N2545PMatter Steven S · Joliet, ILFirst renewal noticeBuilt 1955 · S/N 22-2908 N2546PDadez Jaime G · Browntown, WIS/N 22-2910 N2548ABrown Perry L · Columbia Falls, MTBuilt 1952 · S/N 22-845 N2549PLyons Andrew J · Mansfield, MABuilt 1955 · S/N 22-2913 N254ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496062 N254KPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 4496652 N2551PLimoge Jerome P III · Colorado Springs, COBuilt 1955 · S/N 22-2915 N2554AWalker Michael K · Bartlett, TNBuilt 1952 · S/N 22-850 N2555PJohnson Alwyn J · Karlstad, MNBuilt 1955 · S/N 22-2889 N2556AAllen Trace L · Hurricane, UTBuilt 1952 · S/N 22-853 N2557AHubbard Byron R · Cleburne, TXBuilt 1952 · S/N 22-855 N2557PMcmahon Thomas F · Yakima, WABuilt 1955 · S/N 22-2920 N2559AStefan Leon F · Nickerson, KSBuilt 1952 · S/N 22-857 N2559PSale Reported · Oklahoma City, OKSale reportedBuilt 1955 · S/N 22-2922 N255TJVolar II LLC · Edmond, OKBuilt 2016 · S/N 4496394 N2560PBader Regan R · Saint Libory, NEBuilt 1955 · S/N 22-2923 N2562MPacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 27-7954078 N2565ARoggen Allen J · Caledonia, NYBuilt 1952 · S/N 22-862 N2566PClark William · Easton, MOBuilt 1955 · S/N 22-2929 N2568MDe La Cruz Ronaldo · Cape Coral, FLBuilt 1979 · S/N 27-7954079 N2569AChalmers Aviation LLC · Hyrum, UTS/N 22-871 N256AAAlf Ix LLC · Chicago, ILBuilt 2019 · S/N 4496476 N256ACAtwood Jerry L · Sweet Home, ORBuilt 1956 · S/N 22-3788 N256ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496067 N2570ASlaughter Don Wayne · Farmville, NCBuilt 1952 · S/N 20-937 N2571APeterson Ronald A · Campbell, TXBuilt 1952 · S/N 20-939 N2572ASteinhoff Aaron M · Ethel, WABuilt 1952 · S/N 20-938 N2574AJones Daryl L · Spokane, WABuilt 1952 · S/N 22-866 N2576AChristopher Steven · Claremore, OKBuilt 1952 · S/N 22-868 N2577AHelms Michael R Sr · York, SCBuilt 1952 · S/N 22-869 N2579ASharpe Matthew · Olympia, WABuilt 1951 · S/N 22-870 N257ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496071

Back to AD 85-02-05 R1