Registered aircraft · 210

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:80-25-06-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:80-25-06-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:80-25-06-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:80-25-06-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:80-25-06-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:80-25-06-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.

N388BCAerospace Trust Management LLC · Wilmington, DEBuilt 1975 · S/N D-9786 N3920CN3920c Lc · Wichita, KSBuilt 1976 · S/N 421C0145 N404CRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1977 · S/N 404-0065 N404NEFehlhaber Wolfgang M · Port Orange, FLBuilt 1981 · S/N 404-0857 N40MEUnlimited Boat Sales Inc · Page, AZS/N 421C1241 N40RUMoore Terry Alexander Trustee · Adel, GABuilt 1980 · S/N 421C0878 N411MZSongbird Air LLC · Lakewood, COBuilt 1980 · S/N 421C1002 N413VVGardner John · New Hudson, MIBuilt 1979 · S/N 421C-0641 N418BMOrion Aircraft Holding LLC · Rocky Mount, VABuilt 1982 · S/N 421C1227 N41LJPic Aviation Group LLC · Cornelia, GABuilt 1982 · S/N 421C1252 N420WESwv Aviation LLC · Winter Park, FLBuilt 1981 · S/N 421C1040 N421AAHammett Holdings LLC · Townsend, GABuilt 1982 · S/N 421C1233 N421AGFarm Flysician LLC · Ardmore, OKBuilt 1979 · S/N 421C-0663 N421ARHlc Travel LLC · Perham, MNS/N 421C0904 N421BD421bd LLC · Arab, ALBuilt 1979 · S/N 421C0679 N421BRControl Data Inc · Melbourne Beach, FLBuilt 1976 · S/N 421C0128 N421CGMcguire Rick · Liberty, TXBuilt 1978 · S/N 421C0506 N421CXPatriot Aircraft Specialist LLC · Boynton Beach, FLBuilt 1979 · S/N 421C0694 N421DSN421ds LLC · Villa Rica, GAS/N 421C0169 N421EEBas Part Sales LLC · Greeley, COBuilt 1979 · S/N 421C0692 N421EQEquus Air LLC · Norman, OKS/N 421C0910 N421FZBamert Brett L · Muleshoe, TXBuilt 1981 · S/N 421C1020 N421GShapiro David Michael · Homer, AKS/N 421C0664 N421GEMels Priced Right Custom Carts · Lakeland, FLBuilt 1970 · S/N 421B0109 N421GJAeroventures 8 LLC · Mount Carmel, TNS/N 421C0815 N421GKK2 Aviation LLC · Sanford, NCBuilt 1981 · S/N 421C1053 N421GL421 Partners Georgia LLC · Chatsworth, GABuilt 1984 · S/N 421C1405 N421GMCjk Investment Holdings LLC · Tallahassee, FLBuilt 1976 · S/N 421C0159 N421GPCircle Capital Industrial Iac LLC · Dover, DEBuilt 1977 · S/N 421C0259 N421GSStarlight Aviation LLC · Houston, TXBuilt 1984 · S/N 421C1409 N421HLDodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N 421C0820 N421HPDodson International Parts Inc · Rantoul, KSBuilt 1980 · S/N 421C0831 N421J421j LLC · Chuckey, TNS/N 421C0208 N421JCLonestar Aviation LLC · Las Cruces, NMBuilt 1981 · S/N 421C1099 N421JEBrown Lawson M II DBA · San Diego, CABuilt 1981 · S/N 421C1057 N421JLWagner Distributing Co Inc · Auburn, CABuilt 1977 · S/N 421C0210 N421JMSchuck James M · Downey, CABuilt 1975 · S/N 421B0956 N421JR421jr LLC · Wichita, KSBuilt 1976 · S/N 421C-0094 N421JWWheels Up Aviation LLC · Edmond, OKBuilt 1979 · S/N 421C0665 N421KMWeatherproof Montana LLC · Missoula, MTBuilt 1976 · S/N 421C-0006 N421LEN421le LLC · High Springs, FLS/N 421C0464 N421LKParadise Flyers LLC · Summerland Key, FLBuilt 1981 · S/N 421C1017 N421LLWhirlybird Aviation LLC · Bend, ORBuilt 1983 · S/N 421C1081 N421LQApex A & K LLC · Englewood, FLBuilt 1980 · S/N 421C0883 N421LYMayes John S · Austin, TXBuilt 1980 · S/N 421C0855 N421MDBoss Contract Services LLC · Terry, MTBuilt 1978 · S/N 421C0516 N421MEMeisner Aircraft Inc · Janesville, WIBuilt 1976 · S/N 421C0074 N421MLLps Utilities Inc DBA · Woodstock, ILBuilt 1981 · S/N 421C0880 N421MUN421mu LLC · Missoula, MTBuilt 1977 · S/N 421C0248 N421MYOzark Trails Youth Services Inc · West Plains, MOS/N 421B-0356

Back to AD 80-25-06 R1