Skip to content

Registered aircraft · 22,411

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-08-08-R3') 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-08-08-R3') 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-08-08-R3')
    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-08-08-R3')
  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-08-08-R3')
  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-08-08-R3')
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.

N1857TDieck Michael John · Fayetteville, NCBuilt 1971 · S/N 28-7225006 N1859AAverett University · Danville, VABuilt 2022 · S/N 2881527 N1859TPhil Harris Saddlery Inc · State Road, NCBuilt 1971 · S/N 28-7225009 N185LHPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010066 N186Sold Now Development LLC · Boca Raton, FLBuilt 1980 · S/N 32-8024026 N1860HNighthawks Sanity LLC · Chesterfield, MOBuilt 1977 · S/N 32-7740043 N1860TStokes Charles E · Red Cloud, NEBuilt 1971 · S/N 28-7225010 N1861HElusive Aviation Inc · Pflugerville, TXBuilt 1977 · S/N 32R-7780195 N1861JJordan Walter B · Chehalis, WABuilt 1968 · S/N 28-24299 N1862HKaufman Keith · Reading, PABuilt 1977 · S/N 32R-7780196 N1863JGross Peter J · East Troy, WIBuilt 1968 · S/N 28-24302 N1864JBase 2 Final Aviation LLC · Princeton, TXBuilt 1968 · S/N 28-24303 N1865TStuart William C · Tullahoma, TNBuilt 1971 · S/N 28-7225013 N1867HW Tech Consulting Inc · Kensington, MDBuilt 1977 · S/N 28-7715283 N1868HSodah One LLC · San Ramon, CABuilt 1977 · S/N 28-7725165 N1868JCarlisle David · El Paso, TXBuilt 1968 · S/N 28-24309 N1868TShawley James C · Bolivar, MOBuilt 1971 · S/N 28-7225016 N1869RHarwood John · Waxahachie, TXBuilt 1975 · S/N 28-7690060 N1869TMurray Bryan · Brighton, ILBuilt 1971 · S/N 28-7225018 N186CAScotland Cay Refuge LLC · Saint Petersburg, FLBuilt 1980 · S/N 32R-8013046 N186KBAims Community College · Greeley, COBuilt 2018 · S/N 2881086 N186PPiper Aircraft Inc · Vero Beach, FLS/N 28020293 N186SPClear2 Aviate LLC · Ionia, MIBuilt 1977 · S/N 28-7790514 N186SXRodarte Luis Manuel Jr · Tomball, TXS/N 32-8106084 N1870JFye Benjamin A · Riverview, FLS/N 28-24312 N1870TForeit Valdemar S · Gainesville, FLBuilt 1971 · S/N 28-7225019 N1871TBynum Jeffery A · Bayfield, COS/N 28-7225021 N1872JSubasinghe Kalyani P · Lakewood, CABuilt 1968 · S/N 28-24314 N1872TCarrow Marcus · Yorktown, INS/N 28-7125505 N1873JDonovan James L · Tarrytown, NYBuilt 1968 · S/N 28-24315 N1875JJohnson Kent F · Rancho Murieta, CABuilt 1968 · S/N 28-24317 N1879JDavidson Lucas · Green Springs, OHBuilt 1968 · S/N 28-24323 N187ARPiper Aircraft Inc · Vero Beach, FLS/N 28010087 N187FTTowater Ronnie A · Ocala, FLS/N 28-8216197 N187GJerchau Ryan P · Bellmore, NYBuilt 1978 · S/N 32R-7887235 N187SASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1972 · S/N 28R-7235139 N187SDHelo-Max LLC · Dublin, GABuilt 1989 · S/N 2841065 N187SPFarwick Brent T · Louisville, TNBuilt 1977 · S/N 287790372 N187TCRiesenberg Tyson Robert · Bountiful, UTBuilt 2001 · S/N 3257261 N187TPR G R Holdings LLC · Spring Branch, TXBuilt 2006 · S/N 2843627 N1880TBongartz Christian J · Ramsey, MNBuilt 1971 · S/N 28-7225034 N1881JDavidson Pascal Carl · Savannah, GABuilt 1968 · S/N 28-24325 N1882TSonel Derya · Colorado Springs, COS/N 28-7225037 N1883JAnderson Dan Melvin · Salina, UTBuilt 1968 · S/N 28-24327 N1883TWilkins Joseph K · O Fallon, MOBuilt 1971 · S/N 28-7225038 N1885JGem Aviation Corp · Sugar Land, TXBuilt 1968 · S/N 28-24329 N1886JJones Freddy D · Amsterdam, OHBuilt 1968 · S/N 28-24330 N1886TKoester Deborah J · Courtland, MNBuilt 1971 · S/N 28-7225020 N1887TCulver Investments LLC · Gordon, TXBuilt 1971 · S/N 28-7225033 N1889HPlotnick Daniel G · Foxborough, MABuilt 1977 · S/N 28-7725166

Back to AD 87-08-08 R3