Registered aircraft · 54,015

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.

N68418Moore Michael P · Houston, TXBuilt 1978 · S/N 15282289 N6841ASmooth Flying LLC · Barnwell, SCBuilt 1956 · S/N 28941 N6841XNelson Ricky R W · Mandan, NDS/N 47741 N68422Kasper Sean · Killeen, TXS/N 15282291 N6842FRodriguez Leyla M · Bellflower, CABuilt 1966 · S/N 15063442 N6842MBognar John A · Belgrade, MTBuilt 1975 · S/N 18263856 N6843ECampbell Ronald M · Upland, CAS/N 56343 N6843FMoyers John Jason · Midlothian, VAFirst renewal noticeBuilt 1966 · S/N 15063443 N6843GTracey Corp · Midland, VAS/N 15072343 N6843HWhitefish Mountain Acft Rentals And Flt School LLC · Whitefish, MTBuilt 1975 · S/N 17265604 N6843RArkansas Air LLC · Jackson, WYBuilt 1966 · S/N T210-0243 N6843XBoone Alan · Bangor, MEBuilt 1960 · S/N 47743 N6844MBarker Edward J · Claremore, OKBuilt 1975 · S/N 18263857 N68459Airplanes And Helicopters Of Oregon LLC · Sisters, ORBuilt 1978 · S/N 15282303 N6845EShores Kelly W · Thayer, ILS/N 56345 N6845FHoward Donald E II · Ponca City, OKBuilt 1966 · S/N 15063445 N68460Registration Pending · Sheridan, WYRegistration pendingBuilt 1977 · S/N 17268460 N68475California In Nice Inc · San Jose, CABuilt 1978 · S/N 15282311 N68477Freiburger Thomas M · Belvedere, CABuilt 1978 · S/N 15282312 N6847AEwald Christopher Robert · Blanding, UTBuilt 1956 · S/N 28947 N6847DPietron Spraying Inc · Larimore, NDBuilt 1952 · S/N 25196 N6847FFranko Gregory · Grindstone, PABuilt 1966 · S/N 15063447 N6847RAlpine Aviation LLC · Oklahoma City, OKFirst renewal noticeBuilt 1967 · S/N T210-0247 N68485Dkg Cessna LLC · Flagler Beach, FLS/N 15282313 N6848FWhitehead Mathew S · Leesville, LABuilt 1966 · S/N 15063448 N6848MFitts Wayne T · Independence, ORBuilt 1975 · S/N 18263859 N6848XHinkleman Howard R · Brownsboro, ALBuilt 1960 · S/N 17247748 N6849EHofer Perry L · Doland, SDBuilt 1959 · S/N 56349 N6849FDeangelis Jarrod A · Henderson, NVS/N 15063449 N6849XReiss Alan T · Gig Harbor, WAS/N 17247749 N684MCT&B Aero LLC · Jacksonville, FLS/N 21061604 N684SSecond Wind Aviation Corp · Friday Harbor, WABuilt 1969 · S/N 20700147 N6850BJennings Donald J · Gypsum, COS/N 21062845 N6850ESchott Nicholas F · Burns, ORBuilt 1959 · S/N 56350 N6850GVoorheis Patrica D · Casa Grande, AZBuilt 1970 · S/N 15072350 N6851ECharlie Lima 1 LLC · Jacksonville, FLBuilt 1978 · S/N 17272074 N6851FCarr Thomas W · Grand Blanc, MIBuilt 1966 · S/N 15063451 N6851R6851r LLC · Greeley, COS/N T210-0251 N6852AFabian Ryan S · Vancouver, WABuilt 1956 · S/N 28952 N6852HSetter Jory · Midvale, UTBuilt 1975 · S/N 17265608 N6852RJensen Sid R · Idaho Falls, IDBuilt 1967 · S/N T210-0252 N6853HJohnson Seth W · North Pole, AKBuilt 1975 · S/N 17265609 N6854ADulin Thad L · Midland, TXBuilt 1956 · S/N 28954 N6854ERowe Cecil D · Knoxville, TNBuilt 1959 · S/N 56354 N6854GUniverse LLC · Prospect, KYBuilt 1970 · S/N 15072354 N6854HN6854h LLC · Opa Locka, FLBuilt 1975 · S/N 17265610 N6855ACowley Dale Thomas Trustee · Sandusky, MIS/N 28955 N6855RD & N Holdings Inc · Boca Raton, FLBuilt 1967 · S/N T210-0255 N6856EHigh Plains Agronomics Inc · Milliken, COBuilt 1959 · S/N 56356 N6856MWoodall Larry Douglas · Auburn, WABuilt 1975 · S/N 18263861

Back to AD 87-20-03 R2