Registered aircraft · 72,007

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.

N364STFlight Following LLC · Fayetteville, GABuilt 2005 · S/N 4636364 N364WMMoore Bruce W · Aledo, TXBuilt 2014 · S/N 81899 N364ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881645 N3650RScd Medical LLC · Alexandria, LABuilt 1969 · S/N 28-5747 N36511Worley Regenna G · Ellijay, GABuilt 1978 · S/N 28-7890520 N36516Collum Aviation LLC · Milton, FLBuilt 1978 · S/N 32R-7887048 N3651CHately William · Anchorage, AKBuilt 1978 · S/N R18200295 N3651WTraxler Christopher V · Russia, OHBuilt 1966 · S/N 32-556 N3651ZCrabtree Glenn E · Guthrie, OKBuilt 1960 · S/N 22-7548 N36523Waymire David John · Fishers, INBuilt 1978 · S/N 32R-7887049 N36525Orr Richard J Jr · Anthem, AZBuilt 1978 · S/N 32R-7887050 N3652QNolen David S · Wimberley, TXBuilt 1967 · S/N MA-239 N3652RShales Rene J · Hampshire, ILBuilt 1969 · S/N 28-5756 N3652WValiair Limited Co Trustee · Casper, WYS/N 32-557 N3653NBurch Herbert K · Milan, OHBuilt 1967 · S/N 680025 N3653PWright Michael · Hurricane, UTS/N 22-3404 N3653QFlying Naked Muskteers LLC · Palm City, FLBuilt 1967 · S/N MA-240 N3653RSingh Harsimran · Las Vegas, NVBuilt 1970 · S/N 28-5758 N3653ZMandibles Edward Jr · Lompoc, CABuilt 1960 · S/N 22-7550 N36541Plains Aviation · Mitchell, SDBuilt 1978 · S/N 28-7890521 N36546Lighthouse Drones LLC · New Smyrna Beach, FLBuilt 1978 · S/N 32R-7885193 N3654KBeaber Michael J · Fremont, OHBuilt 1967 · S/N 28-23673 N3654RSierra Delta 1 LLC · Dover, DEBuilt 1969 · S/N 28-5759 N36555Smith Jeffrey D · Murrells Inlet, SCBuilt 1978 · S/N 32R-7885194 N3655NPeterson Jesse D · Wasilla, AKBuilt 1947 · S/N 12-1906 N36563Ware Richard A · Versailles, OHBuilt 1978 · S/N 28-7890513 N36567Kempton Larry G Jr · Grand Junction, COBuilt 1978 · S/N 28-7890522 N3656PKennedy Lukas · Anchorage, AKS/N 22-3407 N3656WNuvision Heaqlth Center · Macomb, MIBuilt 1966 · S/N 32-562 N36574California In Nice Inc · San Jose, CABuilt 1978 · S/N 28R-7837284 N36575Brill Charles F · Spring, TXBuilt 1978 · S/N 32R-7885195 N3657NEstes Aviation LLC · Vicksburg, MSBuilt 1967 · S/N 680027 N3657QFaith Builders Family Church Inc · Rogers, ARBuilt 1968 · S/N M-1136 N3657ZBagdon Albert B · Elbert, COBuilt 1960 · S/N 22-7554 N36582Dias Paul Brian · Bakersfield, CABuilt 1978 · S/N 32R-7887058 N36583Trident Aircraft Inc · Easton, MDBuilt 1978 · S/N 28-7816647 N36588Moseley Richard W · Lakewood Ranch, FLBuilt 1978 · S/N 32R-7885196 N3658WFlying 20 Club Inc · Springfield, ILBuilt 1966 · S/N 32-564 N36590American Aircraft Sales LLC · Lincolnshire, ILBuilt 1978 · S/N 32R-7885197 N36591Piper Aircraft Inc · Vero Beach, FLBuilt 1978 · S/N 32R-7887056 N36593Kentucky Stick And Rudder Academy LLC · Springfield, KYBuilt 1973 · S/N 112-73 N36594Hayward Casey W · Anchorage, AKBuilt 1973 · S/N 578-73 N3659KDumont Mark · Brush Prairie, WABuilt 1967 · S/N 28-23676 N3659MTrent Daniel E · Las Vegas, NVBuilt 1978 · S/N 28-7890320 N3659RInternational Air Services Inc Trustee · Carson City, NVBuilt 1970 · S/N 28-5762 N3659XAiello Bailey H · Eugene, ORBuilt 1968 · S/N 311 N365BSHarders Justin M · Cairo, NEBuilt 2024 · S/N 009 N365CB.R.S. Leasing Inc · Wilmington, DEBuilt 2001 · S/N 2163 N365CCSki Sawmill Family Resort Inc · Ulysses, PABuilt 2004 · S/N 9963CC N365DAJeffries Ian Mcgoff Douglas · Clover, SCBuilt 2013 · S/N 82704

Back to AD 87-10-06 R1