Registered aircraft · 384

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

N100VQNational Aviation Academy Of Mississippi Inc · Clearwater, FLS/N 140 N100WNColumbus State Community College · Columbus, OHBuilt 1979 · S/N 288 N101AJCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1974 · S/N 36-008 N101VSCalspan Corporation · Buffalo, NYBuilt 1969 · S/N 218 N102VSCalspan Corp · Buffalo, NYBuilt 1974 · S/N 180 N103JLThunderun Aviation Corp · Buffalo, NYBuilt 1990 · S/N 026 N103TDTrigger Air LLC · Wilmington, DES/N 31-006 N107RMDierolf Robert Scott · Carrollton, TXBuilt 1982 · S/N 362 N108FLWyoming Aviation Specialist Inc · Green Valley, AZS/N 300 N108JNPremier Jets Inc · Hillsboro, ORBuilt 1980 · S/N 35A-358 N108RBAerotrust Services Corp Trustee · Wilmington, DEBuilt 1976 · S/N 097 N10FNGh Equipment LLC · Dover, DEBuilt 1975 · S/N 015 N10GJGlobal Jetcare Inc · Brooksville, FLBuilt 1975 · S/N 010 N10VJVenture Jets LLC · Lititz, PABuilt 1990 · S/N 018 N111FNBest Aircraft Deals LLC · Salt Lake City, UTS/N 293 N111KRLs 464 LLC · Colorado Springs, COBuilt 1981 · S/N 464 N119BARegistration Pending · Tucson, AZRegistration pendingBuilt 1965 · S/N 23-084 N11GJGlobal Jetcare Inc · Brooksville, FLBuilt 1981 · S/N 425 N121LJN121lj LLC · Elmira, NYBuilt 1996 · S/N 121 N123DGDavis Air LLC · Vero Beach, FLBuilt 1976 · S/N 342 N125FSAircraft Trustee Services Inc Trustee · Dover, DEBuilt 1996 · S/N 125 N127VLE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1991 · S/N 036 N128BGE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 2000 · S/N 212 N129TKBankair Inc · West Columbia, SCBuilt 1979 · S/N 253 N12FNGh Equipment LLC · Dover, DEBuilt 1975 · S/N 016 N12RPRoyal Air Freight Inc · Waterford, MIBuilt 1980 · S/N 278 N133EJHale William Trustee · Loveland, COBuilt 1977 · S/N 133 N135AJN135aj LLC · Englewood, COBuilt 1975 · S/N 036 N135SHMed Air LLC · Wilmington, DEBuilt 1981 · S/N 335 N136JPCasmos LLC · Wilmington, DES/N 35A-359 N139LRBank Of Utah Trustee · Salt Lake City, UTBuilt 1997 · S/N 139 N143CKWings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 143 N154RTRise Aircraft 3 LLC · Tomball, TXBuilt 1998 · S/N 154 N159RABar Aircraft Leasing LLC · Waterford, MIBuilt 1975 · S/N 024 N163CKKalitta Charters LLC · Ypsilanti, MIBuilt 1978 · S/N 163 N165CMUS Crane LLC · Wilmington, DES/N 355 N166PCTechnical Education Services Inc · Virginia Beach, VABuilt 1970 · S/N 166 N171ARThunderun Aviation Corp · Buffalo, NYBuilt 1999 · S/N 171 N175FSJet Set 1 LLC · Kalispell, MTBuilt 1965 · S/N 031 N17AHSpirit Wing Aviation Ltd · Guthrie, OKBuilt 1980 · S/N 316 N17AZSkylink Jets Inc · Fort Lauderdale, FLBuilt 1976 · S/N 35-080 N17GJGlobal Jetcare Inc · Brooksville, FLBuilt 1980 · S/N 320 N181EFAloft Aviation Services LLC · Spartanburg, SCBuilt 1978 · S/N 190 N18RARoyal Air Freight Inc · Waterford, MIBuilt 1999 · S/N 35A-513 N1926SHigh Performance Aircraft LLC · El Cajon, CABuilt 1999 · S/N 180 N1932KSpeed Aviation Holdings LLC · Lewes, DEBuilt 1994 · S/N 099 N193DBDakota Territory Air Museum · Minot, NDS/N 193 N1965LMuseum Of Flight Foundation · Seattle, WABuilt 1965 · S/N 012 N1DEChampion Air LLC · Mooresville, NCBuilt 1990 · S/N 016 N1TWNasa 805 LLC · Whitefish, MTRegistration expired, pending cancellationBuilt 1982 · S/N 476

Back to AD 2005-13-36