Registered aircraft · 149

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

N100CUJani King Aviation LLC · Addison, TXBuilt 1977 · S/N 104 N100FJAvw Equipment Co Inc · Maywood, ILS/N 118 N100KUNion LLC · New Century, KSBuilt 1981 · S/N 183 N100YPJk LLC · Ridgeville, SCBuilt 1988 · S/N 222 N108BKKent Aviation LLC · Midland, TXBuilt 2001 · S/N 305 N108KCV1vr LLC · Wilmington, DEBuilt 1974 · S/N 8 N10FKing Leasing Corp · San Diego, CABuilt 1974 · S/N 12 N10NCHayward Enterprises Inc · High Point, NCBuilt 1980 · S/N 172 N111WHWhiskey Hotel LLC · Houma, LAS/N 167 N134CJSkyview LLC · Wilmington, DES/N 134 N136MVTransnet Aviation Group LLC · Short Hills, NJBuilt 2001 · S/N 311 N147GXAltair Aviation LLC · Missoula, MTBuilt 1987 · S/N 214 N150RJ513 LLC · Newark, DEBuilt 2002 · S/N 324 N150SSSweetener Supply Corp · Brookfield, ILBuilt 1987 · S/N 213 N174BFlying Farmer LLC · Wilmington, DEBuilt 1979 · S/N 142 N175CJFlying Farmer LLC · Wilmington, DEBuilt 1980 · S/N 175 N17AQDalila Aero Inc · Wilmington, DENon-citizen corporation, flight hours not reportedS/N 120 N191NMcm Leasing LLC · Pittsfield, MABuilt 2003 · S/N 334 N197MJSkyview LLC · Wilmington, DES/N 197 N1989BN455jw LLC · Missoula, MTBuilt 1988 · S/N 217 N1JWRed River Aircraft Leasing LLC · Anchorage, AKBuilt 1982 · S/N 200 N200GXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 336 N200WLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 352 N203NCC Aviation LLC · Maiden, NCBuilt 1990 · S/N 203 N204WSPremier Aircraft LLC · East Alton, ILBuilt 1981 · S/N 181 N211ECEast Coast Flight Services Inc · Easton, MDBuilt 1980 · S/N 166 N212FJDodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N 147 N214DVRk-492 Leasing LLC · Miami, FLBuilt 2007 · S/N 350 N214FTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 300 N220CVDodson International Parts Inc · Rantoul, KSBuilt 1988 · S/N 220 N221CBFalcon 50ex 320 LLC · Miami Gardens, FLBuilt 2001 · S/N 320 N222MULanier Air East Coast LLC · Pineville, NCBuilt 1980 · S/N 164 N23FMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 296 N244AFlying Farmer LLC · Wilmington, DEBuilt 1979 · S/N 145 N256VGitsis Nick Trustee · MakatiBuilt 1979 · S/N 151 N25STLewis Garry L · Livingston, LABuilt 1982 · S/N 198 N264RVHfa Specialty Acquisitions LLC · Boca Raton, FLBuilt 2002 · S/N 327 N272DNDel Mar College · Corpus Christi, TXBuilt 1978 · S/N 135 N280BDLcg Enterprises LLC · Greenwich, CTBuilt 2003 · S/N 332 N282TRed Star Aero Holdings LLC · Lewes, DEBuilt 1974 · S/N 42 N291BBattelle Memorial Institute · Columbus, OHBuilt 2001 · S/N 317 N299PRMeregrass Inc · Dublin, TXBuilt 2000 · S/N 299 N29BBattelle Memorial Institute · Columbus, OHBuilt 2005 · S/N 343 N30TEV1vr LLC · Wilmington, DEBuilt 1980 · S/N 152 N311BPWls Enterprise LLC · Portland, ORBuilt 2001 · S/N 314 N313PJRpc Aviation LLC · Fayetteville, ARBuilt 2000 · S/N 302 N315EXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 315 N315SCInternational Skychase Corp · Alachua, FLBuilt 1982 · S/N 130 N316GBWellsprings Aviation LLC · Winston Salem, NCS/N 103 N319CFOcean Drive Bulgaria Corp · Wilmington, DEBuilt 2001 · S/N 319

Back to AD 2001-01-05