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.

N39626Drm Air Group Inc · Lewes, DEBuilt 1978 · S/N 32-7840171 N3962KFolsom Lawrence E · Millington, MDBuilt 1967 · S/N 28-23842 N3962QKalstrom William M · Ekalaka, MTBuilt 1971 · S/N 17260062 N3962RNifong James · Enterprise, ALBuilt 1971 · S/N 28-7105067 N3962TSilvretta LLC · Kalispell, MTBuilt 1967 · S/N 28R-30307 N39633Sandusky Aviation LLC · Edmond, OKBuilt 1978 · S/N 28-7916001 N39637Crawford Ted J DBA · Elma, IAS/N 32R-7887129 N39639Anselmi Alessandro · Cleveland, SCBuilt 1978 · S/N 32R-7887130 N3963TBlessing Stephen L · Bethany, MOS/N 28R-30309 N3963ZMusgrove Jimmy Wayne · Delta Junction, AKBuilt 1962 · S/N 18-7826 N39647Pcl2 LLC · Menomonie, WIBuilt 1978 · S/N 32R-7885233 N3964NListowski John Paul · Galveston, TXBuilt 1968 · S/N 680008 N3964PWard Scot · Belgrade, MTBuilt 1956 · S/N 22-3644 N3964RPerrin Gregory R · Vail, AZBuilt 1971 · S/N 28-7105069 N3964TFisher Joseph A · Conway, ARBuilt 1967 · S/N 28R-30310 N3964WScheineman Wayne · Conroe, TXBuilt 2017 · S/N 1218 N39650Bas Part Sales LLC · Greeley, COBuilt 1978 · S/N 32R-7887132 N39654Scarlet Peregrine LLC · Flagler Beach, FLBuilt 1978 · S/N 32R-7887134 N39659Ruijne Paul · Plainview, TXS/N 32R-7887136 N3965PSlaughter Don Wayne · Farmville, NCFirst renewal noticeBuilt 1956 · S/N 22-3645 N3965RRamsey Brian D · Van Nuys, CABuilt 1971 · S/N 28-7105070 N3965THudgin Louis B · Gilbert, AZBuilt 1967 · S/N 28R-30311 N3965XDevore Randall F · Prescott, IABuilt 1975 · S/N 28-7625002 N3965ZHarmon James E · Eagle River, AKBuilt 1962 · S/N 18-7850 N39660Your Mission LLC · Vinton, IABuilt 1978 · S/N 32R-7887142 N39669Lane Community College · Eugene, ORBuilt 1978 · S/N 44-7995021 N3966RBless Edward L Trustee · Hollister, CABuilt 1971 · S/N 28-7105072 N3966ZLorence James E · Glennallen, AKBuilt 1962 · S/N 18-7852 N39671N39671 Aviation LLC · Wilmington, DEBuilt 1978 · S/N 32-7840175 N39673Signorino Joseph E Trustee · Bath, NCBuilt 1978 · S/N 32R-7887139 N3967KLakes Area Aero LLC · Pelican Rapids, MNS/N 28-23851 N3967QPeterson Dennis E · Cambridge, MNBuilt 1971 · S/N 17260067 N3967UKarduck Craig J · Kingsville, TXBuilt 1987 · S/N H001U N39688N39688 LLC · Provo, UTBuilt 1978 · S/N 28-7990005 N3968KOzdogan Brent · Lawrenceville, NJBuilt 1967 · S/N 28-23852 N3968NJohnson David E · Sunfish Lake, MNBuilt 1968 · S/N 680009 N3968TService Oriented Aviation Readiness (S O A R) · Bolivar, MOBuilt 1967 · S/N 28R-30315 N3968WDiamond C Aviation Llcj · Gentry, ARBuilt 1967 · S/N 32-917 N39690Basin Ag Imaging LLC · Hermiston, ORBuilt 1978 · S/N 32R-7887145 N39697Goldsmith Ronald R · Mansfield, TXBuilt 1978 · S/N 28-7990007 N39698Komjathy Robert S · Brighton, MIBuilt 1978 · S/N 28-7990008 N3969KGrollimund David J · Pendleton, INS/N 28-23853 N3969WFix Edward L · Beavercreek, OHBuilt 1967 · S/N 32-909 N396ACMayfly Aviation LLC · Quincy, FLBuilt 2002 · S/N 895-2002 N396AGSkywest Leasing Inc · St George, UTBuilt 1998 · S/N 28-43163 N396CBReissiger Robert B · Foley, ALBuilt 1973 · S/N 563 N396CPAir 1 LLC · Newark, DEBuilt 1994 · S/N S1683 N396DSJelinek James W Jr · Warrenton, VABuilt 1993 · S/N 20980 N396GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881175 N396JWKunze Lee A · Howards Grove, WIBuilt 2000 · S/N 24501

Back to AD 87-10-06 R1