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.

N4735TUlrich Dennis · London, KYS/N R18201747 N4735VCheney David R · Sun Lakes, AZBuilt 1953 · S/N 30599 N4736NHalter Irving L Jr · Philadelphia, PABuilt 1980 · S/N 18267315 N4737FJelm Gordon E · Aguila, AZBuilt 1978 · S/N 18503552 N4737LSouthwinds Export Inc · Kissimmee, FLNon-citizen corporation, flight hours not reportedS/N 15284228 N4737SMaverick Consulting LLC · Prior Lake, MNBuilt 1979 · S/N R18201406 N4737UMoody Properties LLC · Olympia, WABuilt 1964 · S/N 18051437 N4738BEarhart Robert E · Dallas, TXBuilt 1955 · S/N 31636 N4738GCmk Aerial Inc · Sutton, NES/N 17273335 N4738QNeal Tyler W · Dufur, ORBuilt 1967 · S/N 185-1192 N4738USw Aviation Services Inc · Queen Creek, AZBuilt 1964 · S/N 18051438 N4738XHageness Todd A · Rugby, NDS/N 15064788 N4739DMuddy Creek Aviation LLC · Dayton, VAS/N 17272346 N4739FEberwine David B · Lucas, TXBuilt 1966 · S/N P206-0339 N4739JVero Technical Support Inc · Pensacola, FLBuilt 1979 · S/N 17273672 N4739XKimberly Jack L · Shippensburg, PABuilt 1966 · S/N 15064789 N473KPDuffys Aircraft Sales & Leasing Inc · Neillsville, WIBuilt 1982 · S/N 172RG1132 N4740BCallahan Brian L Trustee · Kuna, IDBuilt 1955 · S/N 31638 N4740EVehorn Richard B · Carrollton, TXBuilt 1982 · S/N 18268264 N4740FSkydive Ricks LLC · Petersburg, OHBuilt 1966 · S/N P206-0340 N4740NGtz No 1 LLC · Kalispell, MTBuilt 1979 · S/N 18267329 N4740QFitzpatrick D L III · Whitefish, MTBuilt 1966 · S/N 185-1194 N4740RCall Tracy J · Carmel Valley, CABuilt 1978 · S/N R18200608 N47417Kirst Forest Mitchell · Fairbanks, AKBuilt 1979 · S/N 15283224 N4741KCrosswind Solutions Inc · Medford, ORBuilt 1979 · S/N P21000272 N4741NCimmaron Flying Inc · Colorado Springs, COBuilt 1979 · S/N 18267330 N4741SOkkb2 Inc · Vancouver, WABuilt 1979 · S/N R18201408 N4741XRessel Erik P · Lakewood, COBuilt 1980 · S/N U20605529 N47422Sfdb Aviation Inc · Pompano Beach, FLBuilt 1979 · S/N 15283225 N47428Nei Jeffrey G · Bemidji, MNBuilt 1966 · S/N 185-1196 N4742EHangen Mark C · Flagstaff, AZS/N 18503853 N4742NRegistration Pending · Wilmington, DERegistration pendingBuilt 1979 · S/N 18267331 N4742UProtocol Enterprises LLC · Holdrege, NEBuilt 1983 · S/N 21064810 N4742XMurphy Chong Yi · Fernandina Beach, FLBuilt 1966 · S/N 15064792 N4743BAmstrup Norm D · North Pole, AKBuilt 1955 · S/N 31641 N4743CFour Three Charlie LLC · Andover, MABuilt 1979 · S/N 21063608 N4743DEss Partnership LLC · Waterford, MIBuilt 1957 · S/N 34843 N4743ERegistered aircraftBuilt 1982 · S/N 18268265 N4743NGallagher Jeff · Rio Oso, CABuilt 1979 · S/N 18267332 N4743QHabersetzer Brian D · Brush Prairie, WABuilt 1967 · S/N 185-1197 N4743SDimitri Bevc · Pleasanton, CABuilt 1979 · S/N R18201409 N4743XAerotech Mapping Inc · Las Vegas, NVBuilt 1980 · S/N U20605530 N4744CDesert Aviation LLC · Kingman, AZBuilt 1979 · S/N 21063609 N4744GJackson Flight Center LLC · Moses Lake, WABuilt 1979 · S/N 17273336 N4744K4744k LLC · Mesa, AZBuilt 1979 · S/N P21000275 N4745DRoman Steven T · Burgettstown, PABuilt 1957 · S/N 34845 N4745GMorris Thomas B · Imlay City, MIBuilt 1948 · S/N 7173 N4745NHowze William Scott · Robstown, TXBuilt 1979 · S/N 18267333 N4745PNorris Phillip A · Stanton, CABuilt 1980 · S/N 15284808 N4746NDenham Stacy L · Chehalis, WABuilt 1979 · S/N 18267334

Back to AD 87-20-03 R2