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.

N199NDDodson International Parts Inc · Rantoul, KSS/N BP-025 N1HXCentralav LLC · Lake Worth, FLBuilt 1978 · S/N BB-361 N1LTWhite River Holdings LLC · Southaven, MSS/N BB-1824 N1MARegistered aircraftS/N LA-3 N1NPNebraska Public Power District · Columbus, NES/N BB1834 N1SMStan Mcnabb Chevrolet Buick Gmc Cadillac Inc · Tullahoma, TNBuilt 2001 · S/N BB-1782 N200ANAirtrex Registration Corp Trustee · Wichita, KSBuilt 1979 · S/N BJ-3 N200BTMid-South Regional Aviation LLC · Tunica, MSBuilt 1977 · S/N BB-293 N200DAGambill Aviation LLC · Shreveport, LABuilt 1982 · S/N BB-1095 N200EARegistered aircraftBuilt 1990 · S/N BB-1368 N200FMSapphire Air II LLC · Camp Hill, PABuilt 2002 · S/N BB-1794 N200GPWesley Partners II LLC · Mount Vernon, TXBuilt 1994 · S/N BB1496 N200GSNavajo Nation · Window Rock, AZFirst renewal noticeS/N BB--1214 N200GWNogottie Landing Co LLC · Amarillo, TXBuilt 1979 · S/N BB-568 N200HDCooper Container Corp · Maynardville, TNBuilt 1981 · S/N BB-987 N200HKHck Aviation LLC · Jupiter, FLBuilt 2001 · S/N BB-1772 N200JLCrest Trading Company · Bakersfield, CABuilt 1975 · S/N BB-40 N200JREngelman Acres Ltd · Edinburg, TXBuilt 1983 · S/N BB-1123 N200NDNorth Dakota Department Of Transportation · Bismarck, NDBuilt 1998 · S/N BB-1612 N200NWViking Transport LLC · Saint Louis Park, MNBuilt 1999 · S/N BB-1691 N200PHPrairie Ventures Aviation LLC · Worthington, MNFirst renewal noticeBuilt 1977 · S/N BB-238 N200PZBeech Transportation Inc · Eden Prairie, MNBuilt 1978 · S/N BB-410 N200RRTexas Dept Of Criminal Justice · Huntsville, TXBuilt 1987 · S/N BB-1282 N200UWTrustees Of The University Of Wyoming · Laramie, WYBuilt 1983 · S/N BB-1155 N200VAVargus Group Inc · Providence, RIBuilt 1977 · S/N BB-246 N200WBTurbo Air Charter LLC · Boise, IDS/N BB-1754 N200WPIdplane LLC · Boise, IDBuilt 1991 · S/N BB-1393 N200WXMorales J Mark Trustee · Corpus Christi, TXBuilt 1979 · S/N BB-680 N200XCTvpx Ars Inc Trustee · North Salt Lake, UTS/N BB-1061 N200ZZAirtrex Aircraft Charlie Inc · Wichita, KSBuilt 1979 · S/N BC-64 N202FFBeech Transportation Inc · Eden Prairie, MNBuilt 2001 · S/N BB-1786 N202NDNorth Dakota Department Of Transportation · Bismarck, NDBuilt 1998 · S/N BB1611 N203DHGuardian Flight LLC · Lewisville, TXFirst renewal noticeS/N BB-1845 N203TASouthwest Aviation Specialties LLC · Tulsa, OKS/N BB-658 N204JTBarbaro Enterprises LLC · Argyle, TXBuilt 1997 · S/N BB1563 N204TPW & W Innovative Enterprises LLC · Douglas, GABuilt 1976 · S/N BB-115 N205EJLynch Flying Service Inc DBA · Billings, MTBuilt 1998 · S/N BB-1634 N205SPState Of Colorado · Englewood, COS/N BB-1826 N205TMSmitty'S Supply Inc · Roseland, LABuilt 2007 · S/N BB-1991 N206PRidgeaire Inc · Jacksonville, TXBuilt 1979 · S/N BB-466 N207HBState Of Washington · Olympia, WABuilt 1995 · S/N BB-1516 N207SBBlackbird Aero LLC · Boca Raton, FLS/N B-69 N208BCOutside In Aviation LLC · Fort Madison, IABuilt 1975 · S/N BB89 N208FDelaware Baron Leasing Partners LLC · Wilmington, DEBuilt 1981 · S/N BB-851 N208SRBardoo Urias L · Massapequa, NYBuilt 1974 · S/N B208 N20AEButler Aviation Inc · Houma, LABuilt 1981 · S/N BB827 N20FWUas Transervices Inc · Boca Raton, FLBuilt 1969 · S/N U-111 N211LGStaggerwing Holdings LLC · Englewood, COBuilt 2000 · S/N BB-1732 N211VPCentral Virginia Aviation Inc · North Dinwiddie, VAS/N B-2 N212HCHcc Air LLC · Las Vegas, NVS/N BB-1791

Back to AD 96-03-13