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.

N5152RAero Marine LLC · Denver, NCBuilt 1974 · S/N 17263369 N5153DFree Fall Gulf LLC · La Grange, TXBuilt 1958 · S/N 51253 N5153RVogel Todd J · Bishop, CABuilt 1978 · S/N R18200637 N5154AA&J Air Sales Inc · San Antonio, TXS/N 21063289 N5154DCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1979 · S/N 17272436 N5154FGilstrap William D · Catoosa, OKBuilt 1965 · S/N 17253004 N5154QDemio Douglas · Westbrook, CTBuilt 1973 · S/N 17261767 N5154RKakkar Sunit · Buena Park, CABuilt 1974 · S/N 17263371 N5154TCatalpa Lane Aviation LLC · Raymond, OHBuilt 1981 · S/N R18201825 N5155DPritt Joseph H · Wasilla, AKBuilt 1958 · S/N 51255 N5155JCisco Aero LLC · Cisco, TXS/N 17273717 N5155KSuno LLC · Calhan, COBuilt 1980 · S/N 17273992 N5155PKline John C · Wolcottville, INBuilt 1981 · S/N 15284885 N5155UFlying Unicorn LLC · Aurora, ILBuilt 1980 · S/N 172RG0263 N5156AFrantz Douglas M · Mustang, OKS/N 28156 N5156ESchwankl Michael James · Wasilla, AKBuilt 1959 · S/N 50456 N5156JWings Over La Aviation LLC · West Hills, CABuilt 1979 · S/N 17273718 N5156QN5156q Inc · Elmhurst, ILFirst renewal noticeBuilt 1972 · S/N 21059656 N5156RKookaburra Kiwi LLC · Post Falls, IDBuilt 1974 · S/N 17263373 N5156YCaprock Spraying Inc · Vega, TXBuilt 1980 · S/N 21064100 N5157DPari Gabe M · Ontario, CABuilt 1958 · S/N 51257 N5157KWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1980 · S/N 17273993 N5157NAms Aviation LLC · South Bend, INBuilt 1980 · S/N 18267549 N5157VHarwig Robert P · Longville, MNBuilt 1977 · S/N R1722279 N51580Middletown Regional Flight Training Institute LLC · Middletown, OHBuilt 1980 · S/N 17274323 N51582Flight School Of Gwinnett Inc · Lawrenceville, GAFirst renewal noticeBuilt 1981 · S/N 17274324 N5158EHuettl Austin · Liberty Hill, TXBuilt 1978 · S/N 17271743 N5158QAnglin Cheryl · Jackson, MSBuilt 1973 · S/N 17261769 N5158RBrandenburg Idu LLC · Brenham, TXBuilt 1974 · S/N 17263375 N51594Candace A Larned Enterprises Inc · Long Beach, CABuilt 1980 · S/N 17274326 N5159ADavis Nicholas R · Madera, CABuilt 1979 · S/N 21063292 N5159DFleming James Daniel · Kansas City, MOBuilt 1958 · S/N 51259 N5159NO Bleness Kevin W · Bethel, AKBuilt 1980 · S/N 18267550 N5159RBackcountry Adventures LLC · Big Lake, AKBuilt 1976 · S/N 18503011 N5159UPostolnikov Paul V · Graham, WABuilt 1980 · S/N 172RG0265 N515BBQuad B Flying LLC · Mitchellville, IABuilt 1978 · S/N R18200486 N515BFDelaware Aviation LLC · Sidney, NYFirst renewal noticeBuilt 1950 · S/N 7526 N515CLProfessional Pilot Services LLC · Miami, FLS/N 18255135 N515EDBlue Sky Pilots Inc · Salem, ORBuilt 1975 · S/N 17265354 N515HE2f Trade LLC · Gainesville, TXS/N 21061457 N515LXJones Johnny V · Crab Orchard, KYS/N 17250603 N515MAAdams Scott M · Seabrook, TXS/N 1851070 N515MBMoxie Air LLC · Winston Salem, NCBuilt 1982 · S/N 18268202 N515NAikens Susan R · Delta Junction, AKBuilt 1951 · S/N 19987 N515RDWings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17264049 N515RTCemco Industrial Park LLC · Belen, NMBuilt 1976 · S/N 21061235 N515RVFlying Adventures Tm LLC · Talkeetna, AKBuilt 1975 · S/N A1500594 N51608Commonwealth Of Kentucky · Frankfort, KYBuilt 1967 · S/N R1720255 N5160ABowden Aaron C · Yuma, AZBuilt 1955 · S/N 28160 N5160DPatton Jay A · Hobbs, NMBuilt 1958 · S/N 51260

Back to AD 87-20-03 R2