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.

N4725FHigh Peak Air LLC · Vernal, UTBuilt 1966 · S/N P206-0325 N4725GRegistration Pending · Tampa, FLRegistration pendingS/N 17273330 N4725KBoomerang Air LLC · Cedar Park, TXBuilt 1975 · S/N 18263724 N4725UAntique Aircraft And Automobile LLC · Van Alstyne, TXBuilt 1964 · S/N 18051425 N47261Future American Aviators LLC · Davie, FLS/N 15283204 N47268Jones Benn D · Bell, FLBuilt 1979 · S/N 15283206 N4726BMurray Kenneth · Parkville, MDBuilt 1979 · S/N 15283600 N4726ESky Hopper LLC · San Jose, CABuilt 1982 · S/N 18268262 N4726GAckerman Timothy M · Barnesville, OHS/N 17273331 N4726KEllis Thomas Troy · Slidell, LABuilt 1975 · S/N 18263725 N4726QBecker Flying Service Inc · Hartington, NEBuilt 1976 · S/N 18802496T N4726UMonogram Aviation Services LLC · Coeur D Alene, IDS/N U20605070 N4726XDoebler H Andrew · Myrtle Beach, SCBuilt 1966 · S/N 15064776 N4726YMeisner David B · Meridian, IDBuilt 1980 · S/N 21063994 N4727D4 Leaf Clover Leasing LLC · Murrieta, CABuilt 1979 · S/N 17272341 N4727GDelaney Patrick · Marion, TXS/N 17273332 N4727HJet & Rotor Aviation LLC · Sacramento, CABuilt 1979 · S/N 15283971 N4727KSchau Donna · Post Falls, IDBuilt 1975 · S/N 18263726 N4727NState Of Wisconsin · Madison, WIBuilt 1979 · S/N 18267316 N4727XN4727x LLC · Palmdale, CAS/N 15064777 N4728BN4728b Cessna 180 LLC · Colorado Springs, COBuilt 1955 · S/N 31626 N4728DMoore James Herbert III · Fairbanks, AKS/N 34828 N4728GHidalgo Ciro R · Granbury, TXS/N 17273333 N4728KCloud Dodgers Flying Club Inc · The Villages, FLBuilt 1975 · S/N 18263727 N4728NSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N 18267317 N4728TThree Prop LLC · Dallas, TXBuilt 1981 · S/N R18201746 N4729CSullivan David C · St George, UTBuilt 1979 · S/N 21063604 N4729KAlkire Jay · Boerne, TXBuilt 1975 · S/N 18263728 N4729WMichael J Kraynick Pllc · Hailey, IDBuilt 1965 · S/N 21058621 N472BWCernek Megan Faith · Elton, LAS/N 18258970 N472JSTaylor Kirk B · Houston, TXS/N 17701730 N472KPB2 West Corp · Winona, MNBuilt 1981 · S/N 172RG0922 N472NMMission Aviation Fellowship · Nampa, IDS/N 20700786 N4730BPotter Jay O · Charlotte, NCBuilt 1979 · S/N 15283602 N4730DRd Simpson Consulting LLC · Luling, TXBuilt 1958 · S/N 34830 N4730EState Of Alaska · Kodiak, AKBuilt 1979 · S/N 18503848 N4730NThompson Sheila M · Natchez, MSBuilt 1979 · S/N 18267319 N4730QLindsey Brad A · Dubois, WYBuilt 1966 · S/N 185-1184 N4730XDawson Allen J · Wshngtn Ct Hs, OHS/N 15064780 N4732VGeneral Aviation Support Corp · Rosamond, CABuilt 1980 · S/N 172RG0371 N4733DWycoff Shannon M · Baton Rouge, LABuilt 1979 · S/N 17272344 N4733N4733n LLC · Elberon, NJBuilt 1979 · S/N 18267322 N4733UEicher Marlin Dale · Sterling, AKBuilt 1964 · S/N 18051433 N4734ANewman Macy M · Plano, TXBuilt 1979 · S/N A1520885 N4734EEnergy Transfer Aviation LLC · Spring, TXBuilt 1982 · S/N 18268263 N4734NWood Daniel Matthew · Yelm, WABuilt 1979 · S/N 18267323 N4734XMclennon Daniel C · Boynton Beach, FLBuilt 1966 · S/N 15064784 N47354Wings Over Texas Holdings LLC · Denton, TXBuilt 1979 · S/N 15283220 N4735NAnderson Wood Products LLC · Ellington, MOS/N 18267324 N4735PMarchman & Assosiates Inc · Krum, TXS/N P21000092

Back to AD 87-20-03 R2