Registered aircraft · 54,019

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.

N241DAMonard Larry R · Anadarko, OKBuilt 1960 · S/N 57563 N241EPiedmont Aviation Leasing LLC · Monticello, GABuilt 1971 · S/N 17259889 N241KSCrane Kermit J · Topeka, KSBuilt 1973 · S/N 17262602 N241NYColonial Aviation LLC · N Prince George, VAS/N 17256479 N241PFForsyth Huston J · New Orleans, LAFirst renewal noticeBuilt 1973 · S/N 15075274 N241PLAirplane And Drone Flight Instruction LLC · Orlando, FLBuilt 1985 · S/N 17276422 N241RDRegistration Pending · Missoula, MTRegistration pendingBuilt 1975 · S/N 18502934 N241RGAmerican Patrols Inc · Midland, TXBuilt 1973 · S/N 17261916 N241RRRoss Riley C · Colorado Springs, COS/N 15073611 N241SRLeman Joseph A · Anchorage, AKBuilt 1965 · S/N 18256316 N241WMWildman Air LLC · Mckinney, TXBuilt 1973 · S/N 18502253 N2420DThomas Ryan J · Anchorage, AKBuilt 1952 · S/N 20572 N2420JRailsback Craig S · Huntington Beach, CAS/N 15065520 N2420SNighthawk Inc · Dallas, TXBuilt 1962 · S/N 18051139 N2420UAylmer Debra L · Black Creek, GABuilt 1963 · S/N 17250020 N24214Mckinney Brett A · Hackleburg, ALBuilt 1977 · S/N 15280154 N2421CGeisler Mark · Dallas, TXBuilt 1954 · S/N 30721 N2421FDeckload Aviation LLC · Kodiak, AKBuilt 1965 · S/N 18051621 N2421LPerdue Dustin W · Mooresville, INBuilt 1966 · S/N 17255621 N2421QAristigue Brothers LLC · Sierra Vista, AZBuilt 1966 · S/N 18257621 N2421UWiney Jonathan · Michigan City, INS/N 17250021 N2421XMills Michael N Jr · Granbury, TXBuilt 1965 · S/N 18256321 N2421YAzflygal LLC · Phoenix, AZS/N 17249721 N24227Styer Michael J · Amarillo, TXBuilt 1955 · S/N 31504 N2422LTravis Equipment LLC · Bee Cave, TXBuilt 1966 · S/N 17255622 N2422RAbecca Corp · Jackson, MIBuilt 1964 · S/N 18255522 N2423ACcf Ventures Inc · Bangor, MES/N 18504225 N2423DWatkins Veronica J Trustee · Sparks, NVBuilt 1952 · S/N 20575 N2423EGood Flight Aviation LLC · Stockton, CABuilt 1978 · S/N 17271276 N2423FSwalling Paul C · Anchorage, AKBuilt 1965 · S/N 18051623 N2423JHarris Patrick S · Chamberlain, SDS/N 15065523 N2423LBig Hook Wilderness Camps LLC · Snowmass Village, COBuilt 1966 · S/N 17255623 N2423SAircraft Sales LLC · Caledonia, MIBuilt 1976 · S/N 21061275 N2423UChord Line LLC · Homer, AKBuilt 1963 · S/N 17250023 N2423XCarrier Peter · Skowhegan, MEBuilt 1965 · S/N 18256323 N2423YStevens Mark E · Virgilina, VABuilt 1962 · S/N 17249723 N24242Fly Sky Ads LLC · Manalapan, NJBuilt 1977 · S/N 15280170 N2424LRoberts Steven R · Palo Verde, AZBuilt 1966 · S/N 17255624 N2424Q24q Inc · Cedar City, UTBuilt 1966 · S/N 18257624 N2424RCurlee Derek · Yoakum, TXBuilt 1964 · S/N 18255524 N2424YBeek Nigel A · Pembroke Pines, FLBuilt 1962 · S/N 17249724 N2425CGiovanini Terry L · Bozeman, MTBuilt 1979 · S/N 18267471 N2425GMccune Charles · Metamora, ILBuilt 1959 · S/N 51725 N2425LZappia Jonathan L · Yucaipa, CABuilt 1967 · S/N 17255625 N2425RDietze Weldon W · Seguin, TXBuilt 1964 · S/N 18255525 N2425SPark Sung S · Marana, AZBuilt 1976 · S/N 21061276 N24260Aerial Banners Inc · Pembroke Pines, FLBuilt 1977 · S/N 15280180 N24261Citabria Inc · Auburn, CABuilt 1977 · S/N 15280181 N24264Sunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15280183 N24266Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15280185

Back to AD 87-20-03 R2