Registered aircraft · 657

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:91-25-08-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:91-25-08-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:91-25-08-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:91-25-08-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:91-25-08-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:91-25-08-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.

N53MJAviation Hangar Foam Specialists LLC · Tucson, AZBuilt 1979 · S/N 421C0667 N540CASpradlin Flying Service Inc · Petersburg, TXBuilt 1976 · S/N 421C-0144 N540CCAndriopulos Salguero Inc · Hialeah, FLS/N 421C0675 N540GCAerosmith Aviation Inc · Longview, TXS/N 425-0026 N5417CExecutive Aircraft Management Services LLC · Pompano Beach, FLS/N 421C0012 N5421FAlvey Chad R · Bargersville, INBuilt 1979 · S/N 421C0660 N543KPRedcell Air Inc · Miami, FLBuilt 1981 · S/N 4250101 N543PMPhillips Brant · Franktown, COS/N 421C0280 N5478GOn Wings Of Eagles LLC · Valley Center, CABuilt 1976 · S/N 421C0225 N5497GRichardson Farms Land Mgt Inc · Pittsfield, ILS/N 421C0244 N54CRCage Presnall C · Falfurrias, TXS/N 421C0812 N54TTRedcell Air Inc · Miami, FLBuilt 1981 · S/N 421C1054 N553TSLow Country Air LLC · Augusta, GABuilt 1985 · S/N 425-0214 N554CCAmg/Sherfick Aviation LLC · Noblesville, INBuilt 1982 · S/N 421C1228 N5554GGaluk Douglas P · Wisconsin Rapids, WIBuilt 1977 · S/N 421C0249 N555KKGe Flyer 1 LLC · Sheridan, WYS/N 421C1022 N558BFMatrix Aviation LLC · Birmingham, MIS/N 421C0845 N55ACHaskell Corp · Bellingham, WAS/N 425-0020 N55RLSound Harbor Aviation LLC · Wilmington, NCS/N 421C1071 N55WSFour To One LLC · Decatur, ALBuilt 1976 · S/N 421C0073 N567WAJasper Aviation Inc · Jasper, ALS/N 421C-0713 N56RXKing Cobra Investments LLC · Rancho Cordova, CABuilt 1976 · S/N 421C0207 N577KGMccloy Mark T · Tatum, NMS/N 421C0906 N577PAWm Ragsdale Co · Independence, MOBuilt 1984 · S/N 425-0194 N577RJAviation Trust Company LLC · Oklahoma City, OKBuilt 1981 · S/N 421C1108 N57WAE2 Hangar LLC · Folsom, CAS/N 421C0451 N585PASaltzy Seas LLC · West Palm Beach, FLBuilt 1981 · S/N 425-0047 N588TBVlot Cole T · Wellington, NVBuilt 1976 · S/N 421C0064 N589STCurtis & Son Vacuum Service Inc · Liberty, TXS/N 421C0644 N58ZPCk Investor Inc · Lubbock, TXS/N 421C0705 N5CEAvion Capital Corp · Anchorage, AKBuilt 1981 · S/N 425-0135 N5NNRkgrier LLC · Beckley, WVS/N 421C0446 N5UTK&L Salty Air LLC · Stephenville, TXBuilt 1976 · S/N 421C0101 N600DCHerron Aviation Group LLC · Dexter, MIS/N 421C1007 N602DCKeystone Xpress LLC · Rostraver Twp, PAS/N 421C0864 N605DCT&C Aviators LLC · Green Cove Springs, FLS/N 421C-1005 N605SRPlane Fun Inc Tr Trustee · Snellville, GABuilt 1981 · S/N 421C1041 N60GMInternational Air Services Inc Trustee · Carson City, NVS/N 421C-0828 N6115CHat Investments LLC · Spartanburg, SCS/N 421C0890 N6161XGolden Eagle Aircraft LLC · Boulder, COS/N 421C0895 N616MGSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 425-0087 N617CCRiley Livestock Inc · Mayfield, KYS/N 421C0897 N619ACFeed Yard Industrial Solutions LLC · Amarillo, TXBuilt 1977 · S/N 421C0336 N61AJCoco Air Ltd Trustee · Wilmington, DEBuilt 1978 · S/N 421C0457 N61JV61jv LLC · Chuckey, TNS/N 421C0097 N622TRL C A Inc · Alamo, CABuilt 1980 · S/N 421C0858 N626DRK And L Transportation LLC · Carterville, ILS/N 421C0512 N628CMav Air LLC · Rigby, IDBuilt 1981 · S/N 425-0041 N628MRRichard Chevrolet Inc · Monterey, MABuilt 1981 · S/N 425-0049 N629WMVortech LLC · Woodbury, NYS/N 421C1001

Back to AD 91-25-08 R1