Registered aircraft · 535

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

N100FNMeander Air II LLC · Moon Township, PABuilt 2008 · S/N RK-566 N100SYAerodan Aviation LLC · Alpharetta, GABuilt 1990 · S/N 560-0054 N100WPTads LLC · Kansas City, KSBuilt 1990 · S/N 560-0073 N101WRAtlantic Jet Partners LLC · Pompano Beach, FLBuilt 1991 · S/N RK-41 N105BGC & K Aviation Services LLC · Wilmington, DEBuilt 1995 · S/N 560-0315 N106KHExecutive Air Solutions Corp · Fort Lauderdale, FLBuilt 2001 · S/N RK-323 N107CZPeri Jets Inc · Roanoke, VABuilt 2006 · S/N RK-462 N107SBN107sb Shares LLC · Liberal, KSS/N RK206 N10TDPrairie Air LLC · Aberdeen, SDBuilt 1991 · S/N 560-0096 N1116RCtb Inc · Milford, INBuilt 1996 · S/N RK-116 N111FWAcme Management Co · Fort Worth, TXS/N RK-102 N112BJDg Group Aviation LLC · Bloomfield Hills, MIBuilt 1996 · S/N RK-112 N116ADStone Holdings LLC · Towson, MDBuilt 2002 · S/N RK-338 N118RWCitation N118rk LLC · Houston, TXS/N 560-0389 N119TCFlytat LLC · Missouri City, TXS/N RK-297 N124PPBec-Faye LLC · Grimesland, NCBuilt 1994 · S/N RK-92 N125DJN125dj LLC · Modesto, CABuilt 2007 · S/N RK-531 N12LDSouth Georgia Motor Sports LLC · Wilmington, DES/N 560-0527 N130WWWidewaters Beechjet Aviation LLC · East Syracuse, NYBuilt 1997 · S/N RK-136 N135WCSdac Air LLC · Selma, ALBuilt 1994 · S/N 5600261 N137JCBcaf LLC · Indialantic, FLBuilt 1991 · S/N 560-0137 N13CRPreferred Aviation LLC · Fayetteville, ARS/N 560-0056 N145KKDodson International Parts Inc · Rantoul, KSBuilt 1994 · S/N 560-0276 N154DJWhw Transportation LLC · Jacksonville, FLBuilt 1997 · S/N RK-175 N154JKRacd Holding LLC · Pembroke Pines, FLBuilt 1991 · S/N 560-0128 N155PTWaypoint Aviation LLC · Wilmington, DEBuilt 1994 · S/N 560-0257 N156RKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1997 · S/N RK-156 N157PWRk264 LLC · La Porte, INBuilt 1999 · S/N RK-264 N157TFMeyers Aircraft Trading West LLC · Windermere, FLBuilt 1991 · S/N 560-0157 N15RNExecutive Jet A LLC · Danbury, CTBuilt 1999 · S/N 560-0520 N15SLCp Ultra LLC · Sacramento, CABuilt 1994 · S/N 560-0272 N175CCClemens Aviation LLC · Wichita, KSBuilt 2000 · S/N RK-277 N179TAExecutive Air Solutions Corp · Fort Lauderdale, FLBuilt 2016 · S/N RK-447 N181SGBiotechnologies LLC · Chippewa Falls, WIS/N 560-0181 N188HALouisville Aircraft Leasing LLC · Sellersburg, INBuilt 1997 · S/N RK-164 N190JKAnswers Collective Inc · Hamilton, OHBuilt 1995 · S/N 560-0303 N190KRegistered aircraftBuilt 1994 · S/N 560-0279 N191TPAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 2008 · S/N RK-574 N194SAPennair LLC · Katy, TXBuilt 1993 · S/N 560-0238 N1969JRegistered aircraftBuilt 1994 · S/N 560-0277 N199TTCentral Iowa Aviation LLC · Ankeny, IABuilt 2008 · S/N RK-550 N19HUStoneway Aviation LLC · Prospect, KYBuilt 1991 · S/N 560-0135 N1AGGossett Aviation LLC · Memphis, TNBuilt 2008 · S/N RK-489 N2000X4thd LLC · Midland, TXBuilt 1994 · S/N 560-0249 N203DFFast Air LLC · Liberal, KSBuilt 1998 · S/N RK-203 N204BGPrecision Aviation Inc · Kimberly, IDBuilt 1999 · S/N 560-0503 N208AVTeton Leasing LLC · Pocatello, IDBuilt 1996 · S/N 560-0358 N208VPN771at LLC · Lewes, DES/N 560-0208 N209CV209cv LLC · Bozeman, MTBuilt 1993 · S/N 560-0209 N20CCGunnslinger Air LLC · Destin, FLBuilt 1998 · S/N 560-0467

Back to AD 2008-24-10