Registered aircraft · 4,001

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:81-13-10-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-13-10-R1') 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:81-13-10-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-13-10-R1')
  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:81-13-10-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-13-10-R1')
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.

N79CNew World Wind Ltd · Quartzsite, AZS/N P3370108 N79UReichert John · Port Orange, FLBuilt 1979 · S/N 28R-7931266 N7CXChapman Daniel W · Soldotna, AKBuilt 1972 · S/N P337-0077 N7SKhashimkhodjaev Rustam · Parker, COBuilt 1977 · S/N 28R-7703050 N8002FYowzer LLC · Zephyr Cove, NVBuilt 2004 · S/N 1386 N8004MEuroaviation Inc · KematenBuilt 1981 · S/N 28R-8231017 N800AGAbram Keith · Cedar Hill, TXBuilt 1987 · S/N 251114 N8011FAhmed Sharfaraz · Houston, TXBuilt 1976 · S/N 34-7770080 N8017CBluedevil Aviation LLC · Scottsdale, AZBuilt 1981 · S/N 34-8133200 N801XPAmel Donald · Burleson, TXBuilt 1979 · S/N R1723200 N8027CSeneca 8027c LLC · Spring Lake, MIBuilt 1976 · S/N 347670111 N802AShafer Robert · Grosse Ile, MIBuilt 1968 · S/N 337M0174 N802JMDixon David Scott · Renton, WABuilt 1979 · S/N R1723319 N80339Green Robert H · Lakewood, CABuilt 1981 · S/N 28R-8231019 N8034Lumley William B · Delray Beach, FLBuilt 1974 · S/N 1-0022 N803HLAir Hammer LLC · Wilmington, DEBuilt 1979 · S/N R1723099 N8040EHolt Todd E · Delta, UTBuilt 1968 · S/N 680015 N805WLSilvas Lou · New Braunfels, TXBuilt 2011 · S/N 1 N80603Ellingham Jeffrey B · Perry, GABuilt 1946 · S/N 1008 N80665King Ludlow III · Potomac, MDBuilt 1946 · S/N 1070 N806VRBray Phillip · Greenville, ALS/N 34-7670014 N8072HDuncan Anthony · Princeton, NJBuilt 1979 · S/N 28R-7931295 N8072ZGoing Doug · Mont Belvieu, TXBuilt 1979 · S/N 34-7970458 N8073PLima Sierra Aviation LLC · Kalispell, MTBuilt 1979 · S/N 34-7970478 N80744Miller Kevin R · Addison, TXBuilt 1946 · S/N 147 N80746Gregor Ruslan · West Hartford, CTBuilt 2003 · S/N 1364 N8074WDevens Frederick G · Sussex, NJBuilt 1974 · S/N 6012C N8075HMoore David S · Shrewsbury, MAS/N 28R-7931299 N8075MKrull Benson D · West Richland, WABuilt 1979 · S/N 28R-7931302 N8075QG-Force Aviation LLC · Surprise, AZBuilt 1981 · S/N 28R-8231026 N8076HWisconsin Aviation Inc · Watertown, WIBuilt 1979 · S/N 34-7970484 N8076KIsland Aircraft Corp · Merritt Island, FLBuilt 1979 · S/N 34-7970486 N80776Winslow Donald Raymond · Bullhead City, AZBuilt 1946 · S/N 179 N8081QBormes Aviation Ltd Co · Aberdeen, SDBuilt 1981 · S/N 34-8233075 N8086QBridges Brandon Neal · Beaumont, TXBuilt 1979 · S/N 34-7970496 N8086RColburn Richard S · Fort Mohave, AZS/N 28R-8231027 N8088EMoscardelli David · Mount Pleasant, MIBuilt 1979 · S/N 28-7921045 N8088HCosey R Daniel · Knoxville, TNBuilt 1979 · S/N 28-7921046 N8088TCorcoran Brandon P · Ashland, ORS/N 28-7921053 N8089A8098a LLC · Mesa, AZBuilt 1979 · S/N 34-8070060 N8089QFly First LLC · West Memphis, ARBuilt 1981 · S/N 34-8233078 N8089VPhb LLC · Mesa, AZBuilt 1979 · S/N 28-7921060 N808KBAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N 1477 N80919Registered aircraftBuilt 1946 · S/N 1112 N8096HCic Aviation LLC · Wenatchee, WABuilt 1982 · S/N 34-8233083 N80FCAirplanes LLC · Springfield, ORBuilt 1980 · S/N 34-8070183 N80GYInternational Air Services Inc Trustee · Carson City, NVS/N 25-1198 N80NInternational Air Services Inc Trustee · Carson City, NVBuilt 1974 · S/N P3370197 N80RXMccord Cheryl · Kuna, IDBuilt 1979 · S/N R1723276 N80SMSkyward Aviation Enterprises LLC · Raleigh, NCS/N R172-0187

Back to AD 81-13-10 R1