Registered aircraft · 420

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

N100YCFirst View Aviation LLC · Burlington, COBuilt 1999 · S/N 281 N101JEJeva Air Corp · Plantation, FLBuilt 2004 · S/N 569 N1056BCorral Ventures LLC · Atlantic Beach, FLBuilt 2003 · S/N 499 N107HMSterling Air Service LLC · Corpus Christi, TXBuilt 1999 · S/N 248 N111WGAhuva LLC · Port Alsworth, AKBuilt 2004 · S/N 555 N116SKAir Methods LLC · Greenwood Village, COBuilt 1995 · S/N 116 N11898Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 456 N118APRoadkill Aviation LLC · Indianapolis, INBuilt 1997 · S/N 175 N119QDQuest Diagnostics Clinical Laboratories Inc · Reading, PABuilt 1995 · S/N 119 N11AGDg + Ag LLC · Albuquerque, NMBuilt 2000 · S/N 343 N120QDQuest Diagnostics Clinical Laboratories Inc · Reading, PABuilt 1995 · S/N 120 N1211AStar Child 3 LLC · Sanibel, FLBuilt 2005 · S/N 663 N123CFPc-12 Aircraft LLC · Sanford, FLS/N 286 N1245XKalinin Partners LLC · Juneau, AKBuilt 2003 · S/N 496 N124UVGuardian Flight LLC · Lewisville, TXS/N 124 N125PZStraight Flight Nevada Commercial Leasing LLC · Sparks, NVBuilt 1998 · S/N 209 N1273ATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 603 N129JWAir Methods LLC · Greenwood Village, COBuilt 1996 · S/N 129 N129TPHljh LLC · Corpus Christi, TXBuilt 2005 · S/N 629 N12DZJmp Aircraft Service LLC Trustee · Wasilla, AKBuilt 2001 · S/N 390 N12FAWilke Aviation Group LLC · College Station, TXBuilt 1995 · S/N 117 N12JDYellow Transportation Services Inc · Milwaukee, WIBuilt 1998 · S/N 228 N142LTJk Aviation LLC · Manteca, CAS/N 312 N146PCLmco · Vandenberg Afb, CABuilt 1996 · S/N 146 N149QDQuest Diagnostics Clinical Laboratories Inc · Reading, PABuilt 1996 · S/N 149 N14RDLiftwing Aircraft Holdings LLC · Bellevue, WABuilt 2001 · S/N 384 N153PBCarojake LLC · Spartanburg, SCBuilt 1996 · S/N 153 N156SBSpark Aviation LLC · West Harrison, NYS/N 156 N156WLCl 245 Partners LLC · Erie, COS/N 245 N161AJGruener Garrett · Berkeley, CABuilt 1997 · S/N 161 N162PBPapa Bravo Aviation LLC · Fort Lauderdale, FLBuilt 1996 · S/N 162 N166SBNew Cingular Wireless Pcs LLC · Anchorage, AKBuilt 1999 · S/N 310 N167AREdgemont Aviation LLC · Wilmington, DEBuilt 1999 · S/N 279 N172JSCmfl LLC · Montgomery, ALBuilt 1997 · S/N 171 N172PBLocker Inc · Muleshoe, TXBuilt 1997 · S/N 172 N175ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 566 N17DPWde Aviation LLC · Atlanta, GABuilt 2005 · S/N 648 N18007Stancil Builders Inc · Angier, NCBuilt 2000 · S/N 377 N185PBStellar Envoy LLC · Arvada, COBuilt 1997 · S/N 185 N188PCTimeless USA LLC · Wilmington, DEBuilt 1997 · S/N 188 N190PEUS Department Of The Interior · Boise, IDBuilt 1997 · S/N 190 N191SPJke Helm LLC · Spreckels, CABuilt 1999 · S/N 284 N194CSNortheast Montana Stat Air Ambulance Cooperative · Glasgow, MTBuilt 2003 · S/N 533 N199CMPassmore Aviation LLC · Claremore, OKBuilt 1999 · S/N 262 N1TCMarcare Aviation LLC · Gardnerville, NVBuilt 1995 · S/N 130 N201LFFreedom 2026 LLC · Minneapolis, MNBuilt 1996 · S/N 147 N207STTwo Bells Aviation LLC · Rockville, MDBuilt 1994 · S/N 107 N208CGAspen Homes And Development LLC · Coeur D Alene, IDBuilt 1995 · S/N 132 N209PBValiair Limited Co Trustee · Casper, WYBuilt 2005 · S/N 609 N212PBGuardian Flight LLC · Lewisville, TXS/N 212

Back to AD 98-11-01 R2