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.

N33345Decker Timothy Daniel · Weatherford, TXBuilt 1975 · S/N 34-7570107 N33360Synergy Transport LLC · Albany, ORBuilt 1975 · S/N 34-7570109 N333CTJrm Wings LLC · Farmington, UTBuilt 1977 · S/N R1722655 N333EEHammons Tommy Frank · Atlantic Beach, FLBuilt 1975 · S/N 34-7570268 N333EWDfw Cyber Tech LLC · Melissa, TXBuilt 1977 · S/N 28R-7703271 N33401Innes Associates Insurance Services Inc · Safford, AZBuilt 1975 · S/N 34-7570115 N3346MBromberek Gene T · Cumming, GABuilt 1977 · S/N 28R-7803136 N33475Excelsior Solutions Inc · Pinehurst, NCBuilt 1975 · S/N 34-7570123 N33503Sueltenfuss Tyler G · Boerne, TXBuilt 1967 · S/N R-172-0242 N33512Kennedy John D · Clinton Twp, MIBuilt 1966 · S/N R172-0099 N33646646 Lease Holding LLC · Noblesville, INS/N 34-7570140 N3366VMason Dave Q · San Marcos, CABuilt 1977 · S/N R1722251 N33689Michair LLC · Omaha, NEBuilt 1975 · S/N 34-7570149 N336ADKropp Christian Trustee · Azle, TXBuilt 1963 · S/N 336-0054 N336BHAce Aviation LLC · Mankato, MNBuilt 1964 · S/N 3360125 N336CFRobbins Warren N · Chandler, AZS/N 336-0174 N336FLLambright Jerry A · South Daytona, FLBuilt 1964 · S/N 336-0177 N336GMGlasser Dean · Boswell, PAS/N R1722336 N336JBBarney Julius C · Lutz, FLBuilt 1963 · S/N 336-0071 N336JLErickson Paul · Okahumpka, FLS/N 336-0181 N336JWMusgrove Jimmy Wayne · Delta Junction, AKBuilt 1964 · S/N 336-0189 N336LBas Part Sales LLC · Greeley, COBuilt 1963 · S/N 336-0117 N336LVMarti Jorge · Miami, FLBuilt 1964 · S/N 336-0176 N336TWPair Of Minutes LLC · Marshville, NCBuilt 1963 · S/N 336-0147 N336VRVr Jet LLC · Goshen, INBuilt 1963 · S/N 336-0024 N336W336 LLC · Eagle, IDBuilt 1963 · S/N 336-0156 N33702Hood Frank A · Burlington, NCBuilt 1967 · S/N 337M-0142 N33724Mil2atp Inc · Pikeville, NCS/N 34-7570153 N33739Sale Reported · Crystal, MNSale reportedBuilt 1975 · S/N 34-7570154 N337AFKinetic Concepts LLC · Pensacola, FLBuilt 1967 · S/N 67-21344 N337BMorris Robert D · Laughlin, NVBuilt 1967 · S/N 337-0775 N337BBLewis University · Romeoville, ILBuilt 1969 · S/N 33701194 N337BDSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1973 · S/N 0062 N337BNDestiny Center Inc · Murfreesboro, TNBuilt 1972 · S/N 33701449 N337BTKrall Jeff · Mitchell, SDBuilt 1969 · S/N 33701223 N337CBarney Julius C · Lutz, FLBuilt 1968 · S/N 337-0905 N337CDKeller Stephen P · Wichita, KSBuilt 1973 · S/N 33701495 N337CEBeam David M · Sabina, OHBuilt 1976 · S/N 33701762 N337CGH&J Flight One LLC · Sun City West, AZBuilt 1973 · S/N P3370143 N337DTomalar Inc · Vero Beach, FLNon-citizen corporation, flight hours not reportedBuilt 1966 · S/N 337-0306 N337DEAirbermz LLC · Bloomfield Hills, MIBuilt 1980 · S/N 33701943 N337DWR And R Aircraft Inc · Delray Beach, FLBuilt 1975 · S/N 33701652 N337EWWilson Cecil · Lithonia, GABuilt 1969 · S/N 337-1193 N337FRomain Dennis · Payson, AZBuilt 1973 · S/N 33701547 N337FMBrous James T Trustee · New York, NYBuilt 1997 · S/N 3449028 N337FTMclenaghan Alvin N · Phoenix, AZBuilt 1966 · S/N 3370384 N337GDPorrima Photonix Inc · Las Cruces, NMBuilt 1979 · S/N 33701921 N337GGInterventional Cardiovascular Group Of San Juan In · Laredo, TXS/N 33701429 N337GHInternational Air Services Inc Trustee · Carson City, NVBuilt 1973 · S/N FP3370007 N337GRLor Aviation LLC · Atlanta, GABuilt 1969 · S/N 33701210

Back to AD 81-13-10 R1