Registered aircraft · 54,017

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-20-03-R2') 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-20-03-R2') 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-20-03-R2')
    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-20-03-R2')
  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-20-03-R2')
  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-20-03-R2')
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.

N3909QAdventure Seaplanes LLC · Tower, MNBuilt 1971 · S/N 17260009 N3909SManer Lawrence L II · Lexington, SCBuilt 1964 · S/N 17251109 N3909UGator Aircraft Industries Inc · Winter Springs, FLS/N 15061309 N390DMGurrola Joseph C · Redlands, CABuilt 1969 · S/N 15070334 N390RSSchoene Edward C · Springfield Center, NYBuilt 1976 · S/N 21061514 N3910JNishikawa David H · Davis, CABuilt 1966 · S/N 15065210 N3910LHickerson Sherman · Broken Bow, OKS/N 17254079 N3910SBenzing Blaine L · Caledonia, MNBuilt 1963 · S/N 17251110 N3911FSpencer Jeffrey D · Rushsylvania, OHBuilt 1958 · S/N 36811 N3911QTraining Planes LLC · Tampa, FLBuilt 1971 · S/N 17260011 N3911RPurcell Keith A · Lima, OHS/N 17255411 N3911UGolon Anthony S · Rush City, MNBuilt 1965 · S/N 15061311 N3911VMckenzie James A · Corvallis, ORS/N 18221 N3912DPmn Enterprises LLC · Fremont, WIBuilt 1957 · S/N 34612 N3912PRegistered aircraftBuilt 1978 · S/N P21000074 N3912RBayshore Safety · Pittsburg, CAS/N 17255412 N3912SWalters Gregory · Neodesha, KSS/N 17251112 N3913FTailwinds Inc · Lancaster, PABuilt 1958 · S/N 36813 N3913JGecsey Sandor · Budd Lake, NJBuilt 1966 · S/N 15065213 N3913RClaudy Steven A · Jessup, MDBuilt 1966 · S/N 17255413 N3914DKapowsin Air Sports Ltd · Shelton, WABuilt 1957 · S/N 34614 N3914QAmerican Patrol Inc · Midland, TXBuilt 1971 · S/N 17260014 N3914SMdz Aviation LLC · Orlando, FLBuilt 1964 · S/N 17251114 N3914VBodnar Axel R · Wasilla, AKBuilt 1948 · S/N 18224 N3915DCarlson Thomas J · Gilbert, MNS/N 34615 N3915FBennett Brandon Scott · Fort Worth, TXBuilt 1958 · S/N 36815 N3915UPullum Linda A · Goddard, KSBuilt 1965 · S/N 15061315 N3916JTrimble Aviation Services LLC · Atlanta, GABuilt 1966 · S/N 15065216 N3916RRegistered aircraftBuilt 1966 · S/N 17255416 N3916SSchmitt Rudy · Brookshire, TXBuilt 1964 · S/N 17251116 N3916UGanvini Christian Adrian Roman · Frederick, MDBuilt 1965 · S/N 15061316 N3916VHorn Bradley P · Waterloo, ILS/N 18226 N3916YMelagrano Jeffrey D · Scarsdale, NYBuilt 1964 · S/N 21058416 N3917DBlue Sky Powers N3917d LLC · Dover, DEBuilt 1957 · S/N 34617 N3917FMurphy Michael A · Anchorage, AKBuilt 1958 · S/N 36817 N3917LShipley Kelly R · Warrenton, ORS/N 17254086 N3917RN3917r LLC · Omaha, NES/N 17255417 N3917SScantling Jason H · Bangs, TXBuilt 1963 · S/N 17251117 N3917YSmf Multi Sports LLC · Lewes, DES/N 18253917 N3918JPegasus Horse LLC · Las Vegas, NVBuilt 1966 · S/N 15065218 N3918LBrown Tony A Jr · Calhoun City, MSBuilt 1965 · S/N 17254087 N3918QAviation Academy LLC · Wichita, KSBuilt 1971 · S/N 17260018 N3918RWilliams Christopher · Alvarado, TXS/N 17255418 N3918USutton Gary K · Rexburg, IDS/N 15061318 N3919DPallet Rack Surplus Inc · Conyers, GAS/N 34619 N3919FKonkol Roger E · Lumberton, NCBuilt 1958 · S/N 36819 N3919QMinot Aero Center · Minot, NDBuilt 1971 · S/N 17260019 N3919RCater Tyrone · N St Petersburg, FLBuilt 1966 · S/N 17255419 N3919VBishop Zachary Ryan · Stewartstown, NHS/N 18229 N391DYHartje Ronald V · Sutter Creek, CABuilt 1962 · S/N 15059765

Back to AD 87-20-03 R2