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.

N299MRPlane Viewing LLC · Colbert, WABuilt 2003 · S/N 0753 N299SBCurrier Holdings LLC · Fairbanks, AKS/N HB2 N29BCD' Jm Holdings LLC · Sugar Land, TXBuilt 1974 · S/N P3370172 N29CWHamilton Aerospace LLC · Lovettsville, VAS/N 34-7570306 N29FZTrn Aviation LLC · Mcallen, TXBuilt 1977 · S/N 28R7703052 N29HCInternational Air Services Inc Trustee · Carson City, NVS/N 3449073 N29KLN13kl LLC · Lewes, DEBuilt 2003 · S/N 3302 N29PPBevis Thomas L · Sebring, FLBuilt 1971 · S/N 2061C N2BLInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 25-0104 N2CLSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N 28R-8131054 N2FRMarcum Alan M · Palo Alto, CABuilt 1989 · S/N 25-1211 N2HSIsland Pearl Airways · Doral, FLFirst renewal noticeBuilt 1979 · S/N 34-8070022 N2MUGarrison Peter · Los Angeles, CABuilt 2002 · S/N 1 N2PJMorgan Bryan K · Sacramento, CABuilt 1969 · S/N 337-1161 N2QFAbel Elliot A · Terre Haute, INBuilt 1977 · S/N P3370280 N2QMNorth Casade Air Transport LLC · Manson, WABuilt 1977 · S/N P3370290 N2QPNoess Michael A · Shakopee, MNBuilt 1977 · S/N P3370291 N2TGB2c2 Aviation LLC · Piedmont, CABuilt 1969 · S/N 337-1064 N2UNSuriel Darleny G · New York, NYBuilt 1969 · S/N 28R-31080 N2WLAlces Aircraft LLC · Wilmington, DEBuilt 1990 · S/N 112 N300Texas Sky Masters Inc DBA · Dallas, TXBuilt 1976 · S/N P3370236 N3000FNosense LLC · Kalispell, MTS/N 34-7970044 N3000TN3000t LLC · Townsend, GABuilt 1967 · S/N 337-0600 N30028Cc Aviation Inc · Tracy, CAS/N 34-48019 N3005NRoaring Fork Aviation LLC · Snowmass Village, COBuilt 1979 · S/N 28R-7931055 N3005QParadox Designs Inc · Las Vegas, NVBuilt 1979 · S/N 28R-7931024 N300JTMentor Capital LLC · San Antonio, TXBuilt 1978 · S/N 34-7970074 N30100Jetstream Cowboys LLC · Bloomfield Hills, MIBuilt 1978 · S/N 34-7870463 N3010YPn4 Aviation Holdings LLC · Bishop, CABuilt 1979 · S/N 28R-7931151 N3011MMorcheid Louis W · Slickville, PABuilt 2006 · S/N 925 N3017KSwing Paul M · Scottsdale, AZBuilt 1979 · S/N 28-7921048 N301ABCamber Aviator LLC · Miami, FLBuilt 1979 · S/N 34-7970186 N301ALForhan Michael A · Urbana, OHBuilt 1967 · S/N 3370636 N301SEAmerican Air Academy Inc · Merritt Island, FLBuilt 2004 · S/N 3449304 N3020KGhostwriter Airshows LLC · Hustonville, KYBuilt 1978 · S/N 34-7970099 N3026WAsplund Jonas · Grand, MNBuilt 1979 · S/N 28R-7931126 N3028NPryor Paul Robert · Carrollton, VABuilt 1979 · S/N 34-7970116 N3029WLong Stephen D · Ontario, ORBuilt 1979 · S/N 28R-7931128 N302AZavoina Lawrence D Jr · Roanoke, TXBuilt 1969 · S/N 68-11055 N30303Registration Pending · Meeker, CORegistration pendingBuilt 1968 · S/N 17701181 N3032ALynn University Inc · Boca Raton, FLS/N 3449294 N3033MPhil-Flyers Club Inc · Amarillo, TXBuilt 1977 · S/N 28R-7803160 N30346Cooke Bradley J · Belmont, NCBuilt 1968 · S/N 17701203 N3035KClippert Royal C · Clarkston, MIBuilt 1978 · S/N 28R-7931030 N3037KHeartland Airplanes LLC · Olathe, KSBuilt 1978 · S/N 28R-7931031 N3039KKola-Air LLC · Lewes, DEBuilt 1978 · S/N 28R-7931034 N303CKRegistered aircraftBuilt 2002 · S/N 3449257 N303FWWoodruff Peter M · Kalamazoo, MIS/N 25-0549 N303MMBrown Properties Of Ga Inc · Silver Creek, GABuilt 1977 · S/N 34-7870027 N303WBThompson Randall K · Van Wert, OHBuilt 1996 · S/N 001

Back to AD 81-13-10 R1