Skip to content

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.

N411PBStarfire Consulting LLC · Nisswa, MNBuilt 1983 · S/N 18268309 N411RBOptic Air LLC · St Maurice, IAS/N 18267053 N411RFFoothill Aircraft Sales & Service Inc · Upland, CAS/N 17252216 N411SHHartl Stephen J · Live Oak, FLBuilt 1964 · S/N 18051350 N411SSDalmolin Russell Scott · Globe, AZBuilt 1973 · S/N 17261603 N411TABenz Christopher · Seattle, WABuilt 1968 · S/N R172-0196 N411TSTango Sierra Aviation Inc · Stuart, FLBuilt 1979 · S/N R18201198 N411TTRambod Marc · Taos Ski Valley, NMBuilt 1975 · S/N 21060861 N4121FHarrold Bruce E · Greybull, WYBuilt 1958 · S/N 46021 N4121U150d LLC · Attica, NYS/N 15060121 N4124FNelson David R Co-Trustee · New Richmond, WIBuilt 1958 · S/N 46024 N4125FSale Reported · Addison, TXSale reported, pending cancellationBuilt 1958 · S/N 46025 N4125LEvans Samuel F · Selma, ALS/N 17254194 N4125UOxborrow Andrew Charles · Lake Barrington, ILBuilt 1963 · S/N 15060125 N4126FRider Terry · Corinth, MSBuilt 1958 · S/N 46026 N4126LBritton Jeff J · Forest Falls, CABuilt 1966 · S/N 17254195 N4126PPorebski Peter T · New Port Richey, FLBuilt 1975 · S/N 17702320 N4127FDavolt John E · Independence, KSFirst renewal noticeBuilt 1958 · S/N 46027 N4127LHoldt Farms Inc · Elgin, NEBuilt 1966 · S/N 17254196 N4127ULewis Daniel R · Leesburg, INBuilt 1963 · S/N 15060127 N4128FSkidmore Arnold D · Williamsburg, OHBuilt 1958 · S/N 46028 N4129LIrwin Kristin L · Emporia, KSS/N 17254198 N4129ULangen Kenneth · Bozeman, MTBuilt 1963 · S/N 15060129 N4129VStoddart Ranches Inc · Jordan Valley, ORBuilt 1948 · S/N 18461 N412BPMission Hardward Ltd Co · Savannah, GABuilt 1983 · S/N T30300213 N412CDOppegard Nicholas D · Eagle River, AKBuilt 1967 · S/N 15067488 N412KJTudor Jeff · Orlando, FLBuilt 1978 · S/N R18200464 N412TRoberts Gregory · Scottsdale, AZBuilt 1972 · S/N 21059558 N412WSArnold Jerry W · Lincoln, NEBuilt 1970 · S/N 17701475 N41306Bruns Darcy · Sandia, TXBuilt 1969 · S/N 17258310 N4132FBaldwin Vivian E · Owasso, OKBuilt 1958 · S/N 46032 N4133USween Patrick Jv · Spring Valley, MNBuilt 1963 · S/N 15060133 N4133YBlain Gerhart · Billings, MTS/N 18052828 N4134FGaffney Mark M · Lincoln, NEBuilt 1958 · S/N 46034 N4134LMountain View Aviation Inc · Cedar Bluff, VABuilt 1966 · S/N 17254203 N4134VBelgau Robert J · Fort Pierce, FLBuilt 1948 · S/N 18466 N4135LHudson Kimmine · Erie, COBuilt 1966 · S/N 17254204 N4135UBerry Michael D · Bowie, TXS/N 15060135 N4136LDickerson Richard L · Fort Worth, TXBuilt 1966 · S/N 17254205 N4136UChen Adeline B · West Lafayette, INBuilt 1963 · S/N 15060136 N4136VGauntt Chep R · Goodyear, AZBuilt 1948 · S/N 18468 N4137CN4137c Inc · Redwood City, CABuilt 1979 · S/N 21063566 N4137YMurray Robert Scott · Franconia, NHBuilt 1962 · S/N 185-0337 N4138UHaley William R III · Carrollton, GABuilt 1963 · S/N 15060138 N4139UKremer Victor J · Alexandria, MNS/N 15060139 N413CDBecktold Stanley T · Richland, ORBuilt 1962 · S/N 17249689 N413EBG&M Aircraft Inc · Wheat Ridge, COBuilt 1979 · S/N 172RG0113 N413LBOficinas De Carolina Inc · San Juan, PRBuilt 1981 · S/N 18504200 N413MASterling Flight Training LLC · Jacksonville, FLBuilt 1976 · S/N 17267164 N413TAInfinite Runway LLC · Union City, CABuilt 1981 · S/N 18267922

Back to AD 87-20-03 R2