Skip to content

Registered aircraft · 72,001

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-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.

N1548PUS Aviation Training Solutions · Titusville, FLBuilt 2005 · S/N 0199 N1548RJohnson Jimmy G A III · Edmond, OKBuilt 1975 · S/N AA5B-0048 N1548XSouthern Turf Services LLC · West Palm Beach, FLBuilt 1975 · S/N 32-7540172 N15493Midwest Flying Service Inc · Elgin, NEBuilt 1972 · S/N 28-7310050 N15494Freisitzer Roland Franz · Charlottesville, VAS/N 32-7340045 N15498Universal Management And Mainteneance Co Inc · Enid, OKBuilt 1972 · S/N 32-7340010 N15499Lankford Toby C · Canadian, TXBuilt 1972 · S/N 28-7325080 N154ARPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010049 N154AVDaviation Inc · Willoughby, OHBuilt 1985 · S/N 28-8616018 N154BJDent Air Ltd · Annapolis, MDBuilt 1977 · S/N 32R-7780251 N154BZGrund Joseph R Jr · North Cape May, NJBuilt 1995 · S/N 27-0195 N154DCRocha Jonathan · Prescott Valley, AZBuilt 1969 · S/N 32-40599 N154DSIn Flight Aircraft LLC · Howell, MIBuilt 2004 · S/N 40.461 N154ERN154er LLC · Kissimmee, FLBuilt 1989 · S/N 2841182 N154FTMiloud Chadd K · Fort Worth, TXS/N 28-8216194 N154GRRussell Gregory · Stevensville, MDBuilt 1976 · S/N AA5A-0213 N154MASportsman Airpark Inc · Newberg, ORBuilt 2001 · S/N 260008 N154MDSwenson John E · Belgrade, MTS/N 154MD N154PAParagon Airplane Leasing Co · Fort Myers, FLBuilt 2020 · S/N 28020012 N154PKPerry Patrick J · Dallas, PABuilt 2001 · S/N 154 N154RAFulwiler Air LLC · Green Bay, WIBuilt 2005 · S/N 1391-2005 N154RVLavalley Thomas L · Colorado Springs, COBuilt 2015 · S/N 004 N154TKornchuk Kurt C · Wasilla, AKS/N 18-2268 N154WKObx Airplanes LLC · Manteo, NCBuilt 1974 · S/N 451-74 N154WWAlpha Whiskey 1 LLC · Brandon, MSS/N 31-7952230 N154ZPAirsign Airships America LLC · Williston, FLBuilt 1999 · S/N 104 N15504N15504 LLC · Eatontown, NJBuilt 1972 · S/N 28-7325082 N1550EWilts George W · Streator, ILBuilt 1978 · S/N 17271043 N1550VJar Investments LLC · Kalispell, MTBuilt 1974 · S/N 17263655 N1550XVictors Vectors LLC · Valparaiso, INS/N 28R-7535323 N15510Lok Kevin K · Upper Sandusky, OHBuilt 1972 · S/N 28-7305084 N15514Smedsmo Darrin A · Roseau, MNS/N 32-7340046 N15517Little Ralph D · Rockwall, TXBuilt 1972 · S/N 28-7325085 N15518Registration Pending · Concord, CARegistration pendingBuilt 1972 · S/N 28-7325086 N1551SVoelker Craig C · Mount Pleasant, IABuilt 1972 · S/N 28-7305085 N1551VBumpe Logistics LLC · South Jordan, UTBuilt 1974 · S/N 17263656 N15523Derryberry Clay · Lewisburg, TNBuilt 1972 · S/N 28R-7335065 N15524Brown Gerald · Apple Valley, MNBuilt 1972 · S/N 28R-7335066 N15526Reynolds David K · Bastrop, LABuilt 1972 · S/N 28-7310052 N15529Pattie Donald D · Zephyrhills, FLBuilt 1972 · S/N 34-7350072 N1552JBoles Brian D · Watkinsville, GABuilt 1967 · S/N 28-23956 N15533Standard Day Aviation LLC · Garland, TXBuilt 1972 · S/N 28-7325091 N15534Daly James Kieran · Hopewell, NYBuilt 1972 · S/N 28-7305086 N15537J & J Aviation LLC · Thedford, NEBuilt 1972 · S/N 28-7310053 N15538Schwartz David · Lakeland, FLBuilt 1972 · S/N 32-7300009 N1553JCarr Jason M · Cypress, TXBuilt 1967 · S/N 28-23957 N1553XGreat Divide Aircraft LLC · Louisville, COBuilt 1975 · S/N 32R-7680003 N15544Sedberry Jason A · Kokomo, INS/N 28-7325094 N15545Ungaro James P Sr · Las Vegas, NVBuilt 1972 · S/N 28R-7335068 N1554XBertagna LLC · Chico, CABuilt 1975 · S/N 28R-7535324

Back to AD 87-10-06 R1