Registered aircraft · 499

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:99-16-03') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-16-03') 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:99-16-03')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-16-03')
  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:99-16-03')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-16-03')
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 N101NDFlorida Jet Parts LLC · Fort Lauderdale, FLBuilt 1994 · S/N 037 N101SSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 161 N101VSCalspan Corporation · Buffalo, NYBuilt 1969 · S/N 218 N102LJRegan Aviation LLC · Stateline, NVBuilt 1997 · S/N 102 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 N104RJHalrive Air LLC · Boca Raton, FLBuilt 2012 · S/N 422 N106FFAerial Holdings Lj Inc · Wilmington, DEBuilt 2010 · S/N 375 N107RMDierolf Robert Scott · Carrollton, TXBuilt 1982 · S/N 362 N108FLWyoming Aviation Specialist Inc · Green Valley, AZS/N 300 N10MBAircraft Trustee Services Inc Trustee · Dover, DEBuilt 1999 · S/N 176 N10VJVenture Jets LLC · Lititz, PABuilt 1990 · S/N 018 N111FNBest Aircraft Deals LLC · Salt Lake City, UTS/N 293 N113DJ3d Jets LLC · Orchard Park, NYBuilt 2007 · S/N 307 N117KBAti Jet Inc · El Paso, TXBuilt 1992 · S/N 003 N119BARegistration Pending · Tucson, AZRegistration pendingBuilt 1965 · S/N 23-084 N11AMSupermax Smxm LLC · Los Angeles, CABuilt 1998 · S/N 118 N121LJN121lj LLC · Elmira, NYBuilt 1996 · S/N 121 N1221MAviation Association LLC · Rochester, NYBuilt 2000 · S/N 209 N123DGDavis Air LLC · Vero Beach, FLBuilt 1976 · S/N 342 N125FSAircraft Trustee Services Inc Trustee · Dover, DEBuilt 1996 · S/N 125 N126KLAircraft Fidelity Corp Trustee · Dover, DEBuilt 1984 · S/N 096 N127VLE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1991 · S/N 036 N128BGE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 2000 · S/N 212 N136JXCpjv LLC · Greenville, SCBuilt 1998 · S/N 136 N139LRBank Of Utah Trustee · Salt Lake City, UTBuilt 1997 · S/N 139 N143CKWings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 143 N143LJBchjet3 LLC · Greer, SCS/N 143 N14TURegan Aviation LLC · Stateline, NVBuilt 1993 · S/N 026 N154AKAviation Resources Group Inc · Fort Lauderdale, FLBuilt 1997 · S/N 114 N154RTRise Aircraft 3 LLC · Tomball, TXBuilt 1998 · S/N 154 N155ERAir Medical Services LLC · Denver, NCBuilt 1984 · S/N 55-098 N155SJLopez Fabio · Denver, NCBuilt 1984 · S/N 102 N156DHFs Sean Lee LLC · Rochester, NYBuilt 1996 · S/N 091 N160BPBeeson John S · Houston, TXBuilt 1998 · S/N 138 N160BSSierra Bravo LLC · Galveston, TXBuilt 1997 · S/N 112 N160EEPlane Part Solutions LLC · West Palm Beach, FLBuilt 1996 · S/N 093 N160EMTjh Falcon2 LLC · San Antonio, TXBuilt 1999 · S/N 149 N160GGThin Air Holding LLC · Dover, DEBuilt 1997 · S/N 113 N160SJEcho Acquisitions LLC · Dover, DEBuilt 2008 · S/N 345 N165CMUS Crane LLC · Wilmington, DES/N 355 N166PCTechnical Education Services Inc · Virginia Beach, VABuilt 1970 · S/N 166 N168HLSelectjet Lease LLC · Grand Rapids, MNBuilt 1994 · S/N 041 N168ZZBwc Holdings Ltd · Greenwood Village, COBuilt 1996 · S/N 078 N169LJSelect Jet Lease II LLC · Grand Rapids, MNBuilt 2000 · S/N 60-169 N16CSDodson International Parts Inc · Rantoul, KSBuilt 1997 · S/N 098 N16LJLear Holding Corp · Wilmington, DEBuilt 1986 · S/N 126

Back to AD 99-16-03