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.

N5490CJenkins Dayne Vaughn · Anchorage, AKS/N 19524 N5490ERoberson Terry K · Tampa, FLBuilt 1983 · S/N 18268327 N5490HSuperior Flying Services LLC · Superior, WIS/N 17265462 N54910Somboonsap Patanapong · Oakland Park, FLBuilt 1981 · S/N 17275077 N5491BSmith Richard D II · Luthersville, GABuilt 1956 · S/N 33491 N5491HSky Hogs LLC · Orange Park, FLBuilt 1975 · S/N 17265463 N5491KSale Reported · Rowland, NCSale reportedBuilt 1980 · S/N 17274156 N5491LWinter Sarah A · Hurst, TXBuilt 1980 · S/N 15284321 N5491NLacefield Tommie C · Niceville, FLBuilt 1980 · S/N 18267756 N5491PKs Aviation Inc · Atwater, CABuilt 1981 · S/N 15284958 N5491RSingh Jaspal · Sacramento, CABuilt 1965 · S/N 17253058 N5491TAlpha Mike LLC · Stoughton, MABuilt 1964 · S/N 17251391 N5492CSorensen Bjarne K · Vero Beach, FLBuilt 1950 · S/N 19526 N5492HAcme Aircraft Flying Club LLC · Kalispell, MTBuilt 1975 · S/N 17265464 N5492QMarchant Colby Z · Hazlehurst, GABuilt 1972 · S/N 15073392 N5492TCollins Terry D · Maynardville, TNBuilt 1964 · S/N 17251392 N5493AValley Dairy Farms Inc · Roy, WAS/N 21063469 N5493CHetchler Glenn A · Erie, COBuilt 1950 · S/N 19527 N5493NOcaid Equipment Leasing LLC · Spring Valley, NYBuilt 1980 · S/N 18267757 N5493RFreedom Flight Center Inc · Hardy, NEBuilt 1979 · S/N 172RG0064 N54946Goosfraba LLC · Huddleston, VABuilt 1981 · S/N 17275084 N54947Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17275085 N5494EBloom William K · Wrangell, AKBuilt 1979 · S/N 18503983 N5494PHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1981 · S/N 15284959 N5494TCampbell Barry E · Prescott, AZBuilt 1982 · S/N R18201879 N54951Skylens LLC · Hammond, LABuilt 1981 · S/N 17275087 N54955Space 5 LLC · Fayetteville, GABuilt 1982 · S/N 17275089 N54956Fluke Dennis M · Sunset, TXBuilt 1981 · S/N 17275090 N5495ARzs Enterprises Inc · Finley, NDBuilt 1979 · S/N 21063470 N5495BCable Strong Aircraft Holdings LLC · Tyler, TXS/N 33495 N5495CWallace Tracy C · Santa Rosa, CABuilt 1950 · S/N 19529 N5495DSorbi Aviation Inc · El Cajon, CABuilt 1979 · S/N 17272587 N5495KI Fly High LLC · Mesa, AZBuilt 1980 · S/N 17274160 N5495QNovember Sierra Aviation LLC · Oneill, NES/N 15285113 N5495RLee Ernest J Jr · Danielson, CTBuilt 1965 · S/N 17253063 N5495VPhillips Ruffin P Jr · Lexington, NCBuilt 1975 · S/N 21060964 N54960First Eclipse Ltd · Richmond, VAS/N 17275092 N5496EFair John C · Rockport, TXBuilt 1983 · S/N 18268328 N5496HWilson Charles L · Seattle, WABuilt 1975 · S/N 17265466 N5496QPhillips Michael · Bossier City, LABuilt 1972 · S/N 15073396 N5496RFitzgerald Douglas A · Stockton, CABuilt 1965 · S/N 17253065 N54973Szymanski Tadeusz C · Fort Myers, FLS/N 55217 N5497BBlue Sky Powers N5497b LLC · Dover, DEBuilt 1956 · S/N 33497 N5497NBeelieve LLC · Carmel, INBuilt 1980 · S/N 18267760 N5497SVerbovskiy Vitaliy Viktorovich · Clovis, NMBuilt 1980 · S/N R18201589 N54983Jin Jin Aviation LLC · Anchorage, AKBuilt 1981 · S/N 17275098 N5498CKfg Aviation Inc · Huntersville, NCS/N 19602 N5498HGulf Atlantic Airways Inc · Gainesville, FLBuilt 1975 · S/N 17265468 N5498QAtlanta Technical College · Atlanta, GABuilt 1972 · S/N 15073398 N5498RWilson Dale L · Escalante, UTBuilt 1965 · S/N 17253067

Back to AD 87-20-03 R2