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.

N4865SBowman Steven R · Manteo, NCBuilt 1970 · S/N 32-1296 N4867DFlynn Brian · Auburndale, FLBuilt 1979 · S/N 17272378 N4867L23 Right LLC · Kalispell, MTBuilt 1967 · S/N 28-4221 N4868EVero Technical Support Inc · Pensacola, FLBuilt 1978 · S/N 17271671 N4868LWinningham Matthew P · Prattville, ALBuilt 1968 · S/N 28-5123 N4869ANevill Bernard L · Clare, MIBuilt 1956 · S/N 22-4029 N4869BSchaffer Brandon T · Vlg Of Lakewd, ILBuilt 1984 · S/N 32-8424002 N486BLBlue Line Aviation LLC · Smithfield, NCBuilt 2024 · S/N 2881786 N486DMMoes Sarah J · Rossford, OHS/N 32-286 N486EMMason Edward R Trustee · Wilsonville, ORS/N 001 N486FLBaker Donnie · Christiana, TNBuilt 1971 · S/N 28-7125295 N486JWWade James M · Calhoun City, MSBuilt 1993 · S/N 1398 N486KWilliams Lawrence J II · Tucson, AZBuilt 2005 · S/N 486 N486MAOrange Wing Aviation Inc · Wilmington, DEBuilt 2006 · S/N 2843636 N486MMN486mm LLC · Winter Haven, FLBuilt 2001 · S/N 136 N486PRichardson Joshua R · Mobile, ALBuilt 1965 · S/N 28-21079 N486PARegistered aircraftBuilt 2023 · S/N 2881621 N486TCMonte D Burke · Dallas, TXBuilt 2004 · S/N 18281446 N486WCoyne Thomas E · Fort Collins, COBuilt 2008 · S/N 91435 N4870DSherman Hess M · Poplar Grove, ILBuilt 1979 · S/N 17272379 N4870GCal Aggie Flying Farmers Inc · Davis, CABuilt 1979 · S/N 17273417 N4870LWinyah Aviation LLC · Georgetown, SCBuilt 1967 · S/N 28-4225 N4870TBailey Charles G · Phoenix, MDBuilt 1972 · S/N 32-7200026 N4870UUniversity Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842238 N4871BMeise Fred Walter · Moses Lake, WAS/N 18-4967 N4871CFalvey Paul J · Edgartown, MABuilt 1984 · S/N 28-8490101 N4871RWagner James M · Le Sueur, MNBuilt 1978 · S/N R18200615 N4871SLaingkids LLC · Lewes, DES/N 32-7100017 N4871VBt Aero Precission Flight Accademy LLC · Oakdale, CABuilt 1980 · S/N 172RG0406 N4872AIdaho Wool Growers Assn · Boise, IDFirst renewal noticeS/N 18-4969 N4872DPs N4872d LLC · Green Bay, WIBuilt 1979 · S/N 17272381 N4872HPassanante John L · Newtown, PABuilt 1981 · S/N 18267849 N4872LMartin Marvin J · Conrath, WIBuilt 1968 · S/N 28-4227 N4872SBlocker James Deric · Cave Creek, AZS/N 32-7140054 N4873APapp Jacob R · Fort Edward, NYS/N 18-4971 N4873FFirebrand Nation · Knoxville, TNS/N 28-7725034 N4873G4873g Flying Club Inc · Punxsutawney, PABuilt 1979 · S/N 17273420 N4873LBaker Justin · Titusville, FLBuilt 1967 · S/N 28-4229 N4873RCavu Clearing LLC · Center Harbor, NHBuilt 1978 · S/N R18200616 N4873SBurke Mark S · Kindred, NDBuilt 1979 · S/N R18201440 N4873YCherry Hill Aviation Inc · Freetown, INBuilt 1968 · S/N 25-4675 N4874Goin Jeff Trustee · Polk City, FLBuilt 1968 · S/N 025 N4874SShores Financial LLC · Thayer, ILBuilt 1971 · S/N 32-7100022 N4874TSmith Richard R Sr · Wellington, NVS/N 28R-7235128 N4875DNightwing Productions LLC · Aptos, CABuilt 1967 · S/N 670218 N4875FVan Kirk Ronald · Wichita Falls, TXBuilt 1976 · S/N 28-7725033 N4876FCosta Air Service LLC · Painted Post, NYBuilt 1979 · S/N 17273094 N4876GKing Bryan A · Austin, TXBuilt 1979 · S/N 17273423 N4876SLedford Roland S · Borger, TXBuilt 1971 · S/N 32-7140057 N4876TAyers Terry · Boise, IDBuilt 1972 · S/N 34-7250162

Back to AD 87-10-06 R1