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.

N529TDJohnson Timothy Dean · Walton, KYBuilt 1972 · S/N 17260741 N529TTCarter Casey C · Sanger, TXBuilt 1959 · S/N 52658 N52AJMccarty Aaron T · Wasilla, AKBuilt 1977 · S/N R18200089 N52BJTca LLC · Fountain Hills, AZBuilt 1977 · S/N 177RG1183 N52CRCairns Douglas S · Bozeman, MTBuilt 1968 · S/N 18259237 N52DRJbpm LLC · Otisfield, MEBuilt 1973 · S/N 15075506 N52ENRefuge Properties LLC · Goshen, KYS/N 18263612 N52FFOflanagan Clancy H · Chowchilla, CAS/N 152-82375 N52GVCompass Aviation Maintenance LLC · Shelby, NCBuilt 1978 · S/N R18200393 N52HPHeritage Aviation Management LLC · Headland, ALBuilt 1967 · S/N R1720079 N52JXPinhoc Inc · Winter Garden, FLS/N 15281088 N52KKVon Sternbert Nicholas Josef · Valencia, CAS/N 17700563 N52LERovey Byron G · La Grande, ORBuilt 1952 · S/N 20458 N52MMHappy Sky LLC · Brooklyn, NYS/N 21064870 N52SEPryor Jeff · Santa Barbara, CABuilt 1978 · S/N P21000080 N52TDClear Sky 2020 LLC · Warner Robins, GABuilt 1952 · S/N 20379 N52WJGordon Donald G · Woodburn, INS/N 20795 N53006Hemphill Holdings LLC · Hemphill, TXBuilt 1973 · S/N 18502312 N53009Triple V Aviation LLC · Long Valley, NJBuilt 1981 · S/N 17274658 N5300ARunzel Brothers Aviation LLC · Bensenville, ILBuilt 1979 · S/N 21063356 N5300KSliviak Thomas V · Leechburg, PABuilt 1980 · S/N 17274053 N5300QHopson Larry K · Conroe, TXS/N 15073200 N53010L & T Aviation Inc · Frederick, MDFirst renewal noticeBuilt 1981 · S/N 17274659 N53013Metzler Alan J · Reedsville, PABuilt 1973 · S/N 18502317 N53017Johnston Charles L II · Nashville, TNBuilt 1981 · S/N 17274663 N5301EMaxwell Don P II · Longview, TXBuilt 1978 · S/N 17271827 N5301HCandace A Larned Enterprises Inc · Long Beach, CABuilt 1979 · S/N 15284083 N53023N53023 Aloha LLC · Palm City, FLBuilt 1981 · S/N 17274665 N53025Beumer Ted Anthony · Pensacola, FLBuilt 1981 · S/N 17274666 N53026Oehl Robert · Jacksonville, FLBuilt 1978 · S/N 177RG1327 N53029N53029 Cardinal LLC · Rosharon, TXBuilt 1978 · S/N 177RG1328 N5302NNorthwoods Air LLC · Orono, MEBuilt 1980 · S/N 18267633 N5302RTrinque Robert L Trustee · Plymouth, MABuilt 1965 · S/N 17252823 N5302SHazelip Jason A · Harrodsburg, KYS/N 337-0402 N5302THoak Edward C · Hummelstown, PABuilt 1964 · S/N 17251202 N5302VSniader David J · Miami, FLFirst renewal noticeBuilt 1975 · S/N 21060902 N53032Sutton Aircraft Salvage LLC · Palmer, AKBuilt 1974 · S/N 18502326 N53035International Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 177RG1329 N53036Aviation Gt Inc · Wilmington, DEBuilt 1978 · S/N 177RG1330 N53037Mb Airworks LLC · Palmetto Bay, FLS/N 17274669 N5303BConnolly Joshua K · Vero Beach, FLBuilt 1956 · S/N 33303 N5303EQuinn George F · Amherst, NHBuilt 1978 · S/N 17271829 N5303QWest Prairie Aircraft LLC · Weiner, ARBuilt 1972 · S/N 15073203 N5303SKillpack Kevin R · Rio Rancho, NMS/N R18201538 N5303XRedemption Inc · Kodiak, AKBuilt 1980 · S/N U20605622 N53044Trophy Down LLC · Punta Gorda, FLBuilt 1973 · S/N 18502334 N53045East Hill Flying Club Inc · Ithaca, NYBuilt 1981 · S/N 17274672 N53046Tucker Thomas G · Dillingham, AKBuilt 1973 · S/N 18502336 N5304BJ & B Aviation · New Martinsville, WVBuilt 1956 · S/N 33304 N5304DDelta Enterprises LLC · Kasilof, AKBuilt 1958 · S/N 50202

Back to AD 87-20-03 R2