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.

N4914QGudgel Daniel R · Lemoore, CABuilt 1976 · S/N 18802649 N4914UCaldwell Gregg P · Desert Hot Springs, CAFirst renewal noticeBuilt 1965 · S/N 21058614 N49150Skytrain Aviation LLC · Sumner, ILS/N 15281167 N49151Zhang Victoria · Daytona Beach, FLBuilt 1979 · S/N 15283432 N49159Comer Jacob W · Troy, MOBuilt 1977 · S/N 15281172 N4915CLang Carl R · Harper, TXBuilt 1975 · S/N 18502657 N4915PAubry Nicolas L · Port Jefferson, NYBuilt 1981 · S/N 15284840 N49161Rohan Gerard K Sr · Marion, WIBuilt 1978 · S/N 15281174 N49164Wohali Aviation LLC · Monroe, GAS/N 15281176 N4916APerkins Larry L DBA · Lake Elsinore, CABuilt 1956 · S/N 32313 N4916DHoward Dan E · Hurricane, UTBuilt 1958 · S/N 51016 N4916FSkaggs Steven L · Winters, CABuilt 1966 · S/N U206-0616 N4916GOngstad Anne Whitman · Robinson, NDBuilt 1979 · S/N 17273463 N4917DWright Tyler C · Wilmington, NCBuilt 1958 · S/N 51017 N4917GCarter Richard W · Bumpass, VABuilt 1979 · S/N 17273464 N4917NHanging On The Prop LLC · San Tan Valley, AZBuilt 1979 · S/N 18267454 N49185New Horizon Aviation Inc · Warwick, RIS/N 15283435 N49189Anderson Seth A · Buckeye, AZS/N 15281182 N4918AMerrill Reese D · Brush Prairie, WAS/N 32315 N4918HMarks Aviation Corp · Beverly Hills, CABuilt 1979 · S/N 15284020 N4918QNauta Larry D · Soldotna, AKBuilt 1978 · S/N 18503575 N4918SSilverado Sales Inc · Orem, UTBuilt 1980 · S/N R18201457 N4918UMission Aviation Fellowship · Nampa, IDBuilt 1979 · S/N U20605160 N4918YGrathwohl Air LLC · Bloomfield Hills, MIBuilt 1980 · S/N 21064046 N49191Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15281184 N49194Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15281186 N49197Wilt Aviation Consulting LLC · Sebastian, FLBuilt 1977 · S/N 15281188 N49199Wygant Amanda N · Copper Center, AKBuilt 1977 · S/N 15281189 N4919DDewitz Mark A · Good Thunder, MNBuilt 1958 · S/N 51019 N4919FTice Denzil · Farmville, VABuilt 1979 · S/N 17273102 N4919GRegistration Pending · Fairbanks, AKRegistration pendingS/N 17273466 N4919NKoffeman Edward · Midlothian, TXBuilt 1979 · S/N 18267455 N4919PRiggs Charles A · Pembroke Pines, FLBuilt 1981 · S/N 15284841 N491ACEw Pegasus LLC · Walnut Creek, CAS/N 21063673 N491AFMeyer Terry L · Wayne, NEBuilt 1968 · S/N 18258754 N491CCBarbee Johnny Lee · Fort Stockton, TXBuilt 1971 · S/N 18260654 N49202Skylogix Aircraft LLC · La Verne, CABuilt 1977 · S/N 15281191 N4920ABerry Thomas R · Anchorage, AKBuilt 1956 · S/N 32317 N4920GEye Candy Aviation LLC · Jacksonville, FLBuilt 1979 · S/N 17273467 N4920SExecutive Flyers Inc · Sacramento, CAS/N R18201459 N49215Dukelow Thomas W · Bad Axe, MIBuilt 1979 · S/N 15283437 N4921AHogan William J · Libby, MTBuilt 1956 · S/N 32318 N4921DMills Air Service Inc · Marstons Mills, MABuilt 1958 · S/N 51021 N4921FCa Aviation 172 LLC · Santa Barbara, CAS/N U206-0621 N4921RBas Part Sales LLC · Greeley, COBuilt 1975 · S/N 18802438T N4921VFrumkin Mark Steven · Pittsburgh, PABuilt 1980 · S/N 172RG0416 N49226Parrish Aviation Flight Academy LLC · Southlake, TXBuilt 1979 · S/N 15283439 N4922BAvcorp Holdings Inc · Jackson, MIBuilt 1979 · S/N 15283706 N4922DD Gordon Aviation Inc · La Jolla, CABuilt 1979 · S/N 17272398 N4922GBishop Air LLC · Elk Grove, CABuilt 1979 · S/N 17273469

Back to AD 87-20-03 R2