Registered aircraft · 72,010

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.

N38562Adventures Awaiting LLC · Rogers, ARBuilt 1977 · S/N 32R-7780442 N38564Ck Leasing Services LLC · Wilmington, DEBuilt 1977 · S/N 28R-7737097 N38565Olson Michael S · Ellsworth, KSFirst renewal noticeBuilt 1977 · S/N 28R-7737098 N3856TB & B Flying LLC · Huntingburg, INBuilt 1967 · S/N 28R-30179 N3856WBarr Barry · Memphis, TNBuilt 1966 · S/N 32-797 N3856XIce Cody W II · Houston, MOBuilt 1967 · S/N 149 N3856ZRed Cub LLC · Wilmington, DEBuilt 1961 · S/N 18-7617 N38575Hieb Jared · Amarillo, TXBuilt 1977 · S/N 32R-7780444 N38577Global Aviation Corp · Farmingdale, NYBuilt 1977 · S/N 28-7716201 N38578H & H Contracting And Lease Services Inc · Midlothian, ILBuilt 1977 · S/N 28-7725256 N3857TAmt Services LLC · Virginia Beach, VABuilt 1967 · S/N 28R-30180 N3857ZKnutson Wayne R · Tioga, NDS/N 18-7622 N38580Avier LLC · Beverly, MABuilt 1977 · S/N 28-7725286 N38587Swihart Painting LLC · Bolivar, MOBuilt 1977 · S/N 28R-7737100 N3858MMachias Auto Parts Inc · Jonesport, MEBuilt 1978 · S/N 28-7816628 N3858QPylant Eric Jon · Arnold, CABuilt 1971 · S/N 17259958 N3858TFlying Dots LLC · Daytona Beach, FLBuilt 1967 · S/N 28R-30181 N3858ZGreat Basin Aviation LLC · Eagle River, AKBuilt 1961 · S/N 18-7629 N38597Bad Dog Aviation Inc · Meridianville, ALBuilt 1977 · S/N 32R-7780445 N3859MWhite Roger L · Wallins Creek, KYS/N 28-7890336 N3859NWilson Bryan J · Henderson, NCBuilt 1968 · S/N 680134 N3859TYurek Allen L · Fairfax, VABuilt 1967 · S/N 28R-30182 N3859WFast Lane Aviation Lllp · Hawkinsville, GAFirst renewal noticeBuilt 1966 · S/N 32-801 N3859ZBarnes Welding Inc · Waterville, WABuilt 1961 · S/N 18-7630 N385BCRobinson Eric C · Palmer, AKS/N 526-2010 N385BFGriffith Jonathan E · Newark, NJBuilt 2007 · S/N 6078 N385CCCharlie Charlie Inc · Chimacum, WAS/N 9940CC N385DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843847 N385GRegistered aircraftS/N 64 N385MAPesek Larry Paul · Steinhatchee, FLBuilt 1998 · S/N 18280419 N385SCHogan William J · Libby, MTBuilt 1957 · S/N 18-5437 N385TCLiebl Holdings LLC · Claremore, OKS/N T18208385 N385TEBowers Nick · Mount Hope, WIBuilt 2012 · S/N 91324 N385WWeixler Ronald A · Salt Lake City, UTBuilt 2010 · S/N 90176 N385WKTriva Solutions LLC · El Paso, TXS/N 27-4130 N385XJohns Justin C · Dillingham, AKBuilt 1976 · S/N 7016C N38603Flight Share LLC · Charlotte, NCBuilt 1977 · S/N 28-7790570 N38605Registration Pending · Kalispell, MTRegistration pendingBuilt 1977 · S/N 28R-7737102 N3860RLundgren Christopher B · Graham, TXBuilt 1970 · S/N 28-5833 N3860TTds Property Holdings LLC · Gilmer, TXBuilt 1967 · S/N 28R-30183 N3860WBrasfield Jason · Bonnerdale, ARBuilt 1966 · S/N 32-802 N3860XOverall Aviators LLC · Parsons, KSBuilt 1967 · S/N 155 N3860ZKrueger Robert C · Glenburn, MEBuilt 1961 · S/N 18-7633 N38617Bros Flying Low LLC · Kalispell, MTS/N 32R-7780447 N3861NZekic Zivojin · Austin, TXBuilt 1968 · S/N 680136 N3861PDellinger Jeremiah · Eagle River, AKBuilt 1955 · S/N 22-3553 N3861QLopez Mario J · Torrance, CABuilt 1971 · S/N 17259961 N3861WMendez Fidel Serrano · San Sebastian, PRBuilt 1966 · S/N 32-804 N38628Maxair Inc · Coxs Creek, KYBuilt 1977 · S/N 28-7790572 N38629Red Tail Scholarship Foundation · Tuskegee, ALBuilt 1977 · S/N 28-7790573

Back to AD 87-10-06 R1