Registered aircraft · 1,042

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

N124GADriscoll Health Care Services · Corpus Christi, TXBuilt 1982 · S/N BB-1039 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 N125KSAlpine Aviation Inc · Provo, UTBuilt 1985 · S/N BL-125 N125TECj Brown Express LLC · Graettinger, IABuilt 1992 · S/N BB-1422 N125TSDouble J Aviation Inc · Klamath Falls, ORBuilt 2007 · S/N BB-1993 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 N127TXItb Solutions LLC · Palm City, FLBuilt 1981 · S/N BE-106 N128ASParker Robert E · Corpus Christi, TXS/N BB-1950 N128JPMontrachet Aviation LLC · Santa Ana, CABuilt 1979 · S/N LA-25 N128SFWin Win Aviation Inc · Wake Forest, NCBuilt 1969 · S/N U-87 N128VTState Of Missouri · Jefferson City, MOBuilt 1992 · S/N BB-1442 N12NGNorthrop Grumman Systems Corp · El Segundo, CABuilt 1979 · S/N BB-581 N130BABemidji Aviation Services Inc · Bemidji, MNBuilt 1969 · S/N U-80 N130RLOscar Charlie II LLC · California, MDBuilt 1980 · S/N BT16 N131SJGravitas Aviation LLC · Dallas, TXBuilt 1976 · S/N BB-131 N131SPKauffman Land & Development LLC · Denver, COBuilt 1983 · S/N LA-206 N132NFlying Cowboys LLC · Merced, CAS/N BB-1053 N133GAJab Aire LLC · Wilmington, DEBuilt 1989 · S/N BB1321 N137BABemidji Aviation Services Inc · Bemidji, MNBuilt 1970 · S/N U137 N139JBQuay Ventures LLC · Alto, TXBuilt 1979 · S/N BE-81 N139RRRyan Renae L Trustee · Wichita, KSBuilt 1976 · S/N BB-177 N13FPSafeco Leasing LLC · Port Alsworth, AKS/N B-44 N140RLN140rl LLC · Kalispell, MTBuilt 1982 · S/N BT22 N142EBFly Me LLC · Mc Gregor, TXBuilt 1982 · S/N BB-1042 N143DEAac 585 LLC · Kennesaw, GABuilt 1979 · S/N BB-585 N143TAJrr Motor Sales LLC · Campbellsville, KYBuilt 1984 · S/N BB-1183 N146LCSaratoga Homes Of Texas San Antonio LLC · El Paso, TXBuilt 1982 · S/N BB1046 N14HHDelaware Professional Aviation LLC · Dalton, GABuilt 1988 · S/N BB-1286 N14MVAlpine Aviation Inc · Provo, UTBuilt 1969 · S/N U59 N14NGFirst Avenue Management LLC · Savannah, GABuilt 1987 · S/N BB-1276 N150CNKing Air Investments LLC · Ferriday, LABuilt 1981 · S/N LA-138 N150RLTigress Air III LLC · California, MDBuilt 1982 · S/N BL-50 N150YDSfh Inc DBA · Fargo, NDBuilt 1997 · S/N BB-1561 N151ELCarolina Turbine Sales Inc · Raleigh, NCBuilt 1978 · S/N BB-371 N151WTKo Aviation LLC · Wilmington, DEBuilt 1983 · S/N BB-1151 N152WLHeart One LLC · Little Rock, ARBuilt 1977 · S/N BB-260 N155AVTeton Leasing LLC · Pocatello, IDBuilt 1985 · S/N BB-1216 N155BBRegistration Pending · Greer, SCRegistration pendingBuilt 1997 · S/N BB-1554 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 N162GCUnited States Department Of Interior · Boise, IDBuilt 1985 · S/N BB-1238 N162MCBank Of Utah Trustee · Salt Lake City, UTS/N B137 N162QMartin Foundry Service Inc · Glencoe, ALBuilt 1982 · S/N BB-1104 N164HAUas Transervices Inc · Boca Raton, FLBuilt 1968 · S/N U-60 N1655MMichigan Aeronautics Commission · Lansing, MIBuilt 1999 · S/N BB-1655

Back to AD 96-03-13