Registered aircraft · 286

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:98-20-38-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:98-20-38-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:98-20-38-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:98-20-38-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:98-20-38-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:98-20-38-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.

N100PYTbm Flying Lc · Pampa, TXBuilt 1981 · S/N BB-890 N106RHSouthern Bracing Systems Inc · Armuchee, GABuilt 1978 · S/N BB-428 N108ALRj Flight LLC · Saint Petersburg, FLBuilt 1980 · S/N BB-730 N110GGo Soar LLC · Highland Village, TXBuilt 1980 · S/N BB-792 N111PVHenson Builders LLC · Dallas, TXBuilt 1981 · S/N BB-772 N120RLIsr Platforms LLC · Mclean, VABuilt 1979 · S/N BT-9 N121LBEastern Stearman Inc Trustee · Leesburg, VAS/N BB-475 N124KTGams Air LLC · Doral, FLBuilt 1976 · S/N BB-124 N124WRH.A.I. Services Inc · Justin, TXBuilt 1980 · S/N BB-664 N125BKColoramo Federal Credit Union · Grand Junction, COBuilt 1982 · S/N BB-977 N126JHM&P Aviation LLC · Lakeland, TNBuilt 1980 · S/N BB-595 N127GABeech Transportation Inc · Eden Prairie, MNBuilt 1977 · S/N BB312 N127TACompany Wrench Ltd · Carroll, OHBuilt 1980 · S/N BB-636 N12NGNorthrop Grumman Systems Corp · El Segundo, CABuilt 1979 · S/N BB-581 N130RLOscar Charlie II LLC · California, MDBuilt 1980 · S/N BT16 N131SJGravitas Aviation LLC · Dallas, TXBuilt 1976 · S/N BB-131 N139RRRyan Renae L Trustee · Wichita, KSBuilt 1976 · S/N BB-177 N140RLN140rl LLC · Kalispell, MTBuilt 1982 · S/N BT22 N143DEAac 585 LLC · Kennesaw, GABuilt 1979 · S/N BB-585 N151ELCarolina Turbine Sales Inc · Raleigh, NCBuilt 1978 · S/N BB-371 N152WLHeart One LLC · Little Rock, ARBuilt 1977 · S/N BB-260 N1560Davis Aviation Inc · Brandon, MSS/N BC-09 N15KALighthouse Air LLC · Hobe Sound, FLBuilt 1979 · S/N BB-457 N160SFTriumph Aviation LLC · Gaylord, MIBuilt 1975 · S/N BB-32 N170RLN170rl LLC · California, MDBuilt 1983 · S/N BT28 N175SAGeneral Atomics · San Diego, CABuilt 1976 · S/N BB-183 N176MRegent Trust Corp Trustee · Wichita, KSBuilt 1982 · S/N BB-1029 N177CNRca Aviation 2 LLC · Tempe, AZBuilt 1984 · S/N BB-1191 N17812Best Aircraft Deals LLC · Salt Lake City, UTS/N BB236 N17VAOptimal Aviation Services LLC · Visalia, CABuilt 1980 · S/N BB-670 N187MRJcs Air LLC · Auburn, ALS/N BB-873 N188ALAlm Holdings Delaware 3 LLC · Wilmington, DES/N BB-111 N189ALAlm Holdings Delaware 4 LLC · Wilmington, DES/N BL32 N189APRegistered aircraftBuilt 1975 · S/N BB-59 N18KATreetoppers II LLC · Newark, DEBuilt 1978 · S/N BB-360 N1926A1926a LLC · Auburn, ALBuilt 1981 · S/N BB-922 N199NDDodson International Parts Inc · Rantoul, KSS/N BP-025 N1HXCentralav LLC · Lake Worth, FLBuilt 1978 · S/N BB-361 N200ANAirtrex Registration Corp Trustee · Wichita, KSBuilt 1979 · S/N BJ-3 N200BTMid-South Regional Aviation LLC · Tunica, MSBuilt 1977 · S/N BB-293 N200GWNogottie Landing Co LLC · Amarillo, TXBuilt 1979 · S/N BB-568 N200JLCrest Trading Company · Bakersfield, CABuilt 1975 · S/N BB-40 N200PZBeech Transportation Inc · Eden Prairie, MNBuilt 1978 · S/N BB-410 N200VAVargus Group Inc · Providence, RIBuilt 1977 · S/N BB-246 N200WXMorales J Mark Trustee · Corpus Christi, TXBuilt 1979 · S/N BB-680 N200ZZAirtrex Aircraft Charlie Inc · Wichita, KSBuilt 1979 · S/N BC-64 N203TASouthwest Aviation Specialties LLC · Tulsa, OKS/N BB-658 N204TPW & W Innovative Enterprises LLC · Douglas, GABuilt 1976 · S/N BB-115 N206PRidgeaire Inc · Jacksonville, TXBuilt 1979 · S/N BB-466 N208BCOutside In Aviation LLC · Fort Madison, IABuilt 1975 · S/N BB89

Back to AD 98-20-38 R1