Skip to content

Registered aircraft · 1,079

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

N6561ARandolph Fielding A M · Jackson, TNBuilt 1978 · S/N 27-7954008 N6561YN6561y LLC · Auburn, ALBuilt 1968 · S/N 27-3858 N6573YClendenen William M · Spencer, TNBuilt 1968 · S/N 27-3871 N6578AAir Mods And Repair Inc · Robbinsville, NJBuilt 1978 · S/N 27-7954013 N6579YTaco Tyme LLC · Hobe Sound, FLBuilt 1968 · S/N 27-3878 N6588ARasch Kevin Wayne · Denton, TXS/N 27-7954015 N6588YSo Flipping Busy LLC · Apple Valley, MNBuilt 1968 · S/N 27-3891 N65DFAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1964 · S/N 27-2553 N65DMCorry Aviation LLC · Tequesta, FLBuilt 1973 · S/N 27-7305005 N65SCDocs Air LLC · Buffalo, WYBuilt 1974 · S/N 27-7405445 N6601LUnited Jet Sales Inc · Newark, DEBuilt 1977 · S/N 27-7854047 N660BBKeys Vacation Rentals LLC · Palm City, FLBuilt 1966 · S/N 27-3472 N6613YAviation Group Jmj Inc · Callahan, FLExpired dealer, pending cancellationBuilt 1969 · S/N 27-4395 N6621YDyka Samuel M · Flushing, MIBuilt 1969 · S/N 27-4397 N6623YOrtner Airport LLC · Wakeman, OHBuilt 1968 · S/N 27-3930 N6627YMiller Jay M DBA · Grantsville, MDBuilt 1969 · S/N 27-4399 N6630AIndigo Associates Ltd · Las Vegas, NVBuilt 1978 · S/N 27-7954027 N6644YN6644y LLC · Philomath, ORBuilt 1968 · S/N 27-3958 N6645AAlmost There Air LLC · Daytona Beach, FLBuilt 1978 · S/N 27-7954029 N6647YSkyway Inc · Wilmington, DEBuilt 1968 · S/N 27-3880 N6659YUhles Denny · Bakersfield, CABuilt 1968 · S/N 27-3974 N6664YSmooth Air Inc · Ocala, FLBuilt 1968 · S/N 27-3980 N666KWRegistration Pending · Oklahoma City, OKRegistration pendingBuilt 1972 · S/N 27-7304928 N6670YJohnson Lerell L · Sunrise, FLS/N 27-3987 N6682YMcdermott James R · Somerton, AZBuilt 1968 · S/N 27-4003 N66JWNowell Borders Equipment G P Inc · Edinburg, TXBuilt 1972 · S/N 27-7304967 N6711YAero Services Lc · Woods Cross, UTBuilt 1968 · S/N 27-4039 N6715APacific Fleet Aviation LLC · Rochester, NYS/N 27-7954082 N6716YGot Wings LLC · Woodbury, NYBuilt 1968 · S/N 27-4046 N6730YUrubek Raymond L · Refugio, TXS/N 27-4062 N6739YTropical Interisland Express Corp · Doral, FLBuilt 1968 · S/N 27-4073 N6751YLarson Kris K · Fullerton, CAFirst renewal noticeBuilt 1968 · S/N 27-4079 N6754YNovember Nine One Four Eight Juliet LLC · Fulton, MOBuilt 1968 · S/N 27-4083 N6760AFreestone William W · Saint Augustine, FLS/N 27-7954086 N6768YPiper Aircraft Inc · Vero Beach, FLBuilt 1968 · S/N 27-4100 N6776APacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 27-7954088 N6777YPlaquemines Parish Government · Belle Chasse, LABuilt 1968 · S/N 27-4109 N6786YMuhlenkort Mary Anna · Beresford, SDBuilt 1968 · S/N 27-4122 N6787YCoachron Investments · Grosse Ile, MIBuilt 1969 · S/N 27-4124 N6793YPiper Aircraft Inc · Vero Beach, FLBuilt 1969 · S/N 27-4131 N6809YPiper Aircraft Inc · Vero Beach, FLBuilt 1969 · S/N 27-4147 N680KTalos Aviation Group LLC · Blackstone, VABuilt 1968 · S/N 27-3892 N6810YAtem LLC · Helena, ALBuilt 1969 · S/N 27-4148 N6814YHartwig Acft Fuel Cell Repair Ltd · Hallock, MNBuilt 1969 · S/N 27-4153 N6817YInternational Air Services Inc Trustee · Carson City, NVS/N 27-4156 N6823YWingsleasing LLC · Wichita, KSBuilt 1969 · S/N 27-4163 N6825YDenton J Frederick · Hutchinson Island, FLS/N 27-4165 N6836YOld School Aircraft LLC · Jackson, TNBuilt 1969 · S/N 27-4176 N6843YBarlam Theodore P · Poway, CABuilt 1969 · S/N 27-4187 N6854YChagres Flight Training LLC · Albuquerque, NMBuilt 1969 · S/N 27-4198

Back to AD 81-04-05 R1