Skip to content

Registered aircraft · 1,335

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-23-22-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:99-23-22-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:99-23-22-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:99-23-22-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:99-23-22-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:99-23-22-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.

N100AXApplied Underwriters Inc · Omaha, NEBuilt 1995 · S/N 155 N100UPFj100 LLC · Waco, TXBuilt 1988 · S/N 44 N10112Kc Aviation Stem Inc · Kansas City, MOS/N 193L1064 N10123Sandy Wings LLC · Wilmington, DEBuilt 1971 · S/N 107 N101WFBl Custom Equipment LLC · Cincinnati, OHBuilt 2003 · S/N 197 N104HRXyrec Inc · San Antonio, TXNon-citizen corporation, flight hours not reportedS/N 21525 N104VVAviation Trust Company LLC Trustee · Oklahoma City, OKS/N 53 N105BKJetcom LLC · Lemon Grove, CABuilt 1989 · S/N 070 N105TBAir Force Material Command Esc/Dikl · Hanscom Afb, MABuilt 1968 · S/N 31 N107GLLeep Enterprises LLC · Mishawaka, INBuilt 2002 · S/N 199 N108BKKent Aviation LLC · Midland, TXBuilt 2001 · S/N 305 N108FJBuffalo Valley Ventures Of Tn LLC · Cookeville, TNBuilt 1991 · S/N 108 N108PHYoung Family Aviation LLC · Sugar Grove, ILBuilt 1990 · S/N 87 N10XBmd Leasing LLC · Portland, ORBuilt 2001 · S/N 190 N111FJJfm Air LLC · Wilton Manors, FLBuilt 1993 · S/N 128 N111REX Aviation Group LLC · Beverly Hills, CABuilt 1988 · S/N 49670 N11206United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30578 N116RWCerovest Capital LLC · Lawrenceville, GABuilt 1988 · S/N 058 N118JKRegistered aircraftBuilt 1984 · S/N 445 N120UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 29166 N1210NTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1991 · S/N 105 N12216United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28776 N12218United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28778 N12221United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28930 N12225United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28934 N12238United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28804 N122AVase Corp V · Doral, FLBuilt 1990 · S/N 88 N122UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 29168 N127GKAlliance Aviation Group LLC · Wilmington, DES/N 311 N129TWLogistic Air Inc · Reno, NVBuilt 1976 · S/N 21141 N131LGCharter Express Inc · Little Rock, ARBuilt 1988 · S/N 055 N13227United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28788 N13248Umb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 28808 N134CJSkyview LLC · Wilmington, DES/N 134 N136MVTransnet Aviation Group LLC · Short Hills, NJBuilt 2001 · S/N 311 N13716United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28787 N13718United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28937 N13720United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28939 N13750United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28941 N137GJSolomon Mark Trustee · Wilmington, DEBuilt 1968 · S/N 25 N137SHDream Global Parts LLC · Lawrence, KSS/N 137 N140FJM Investments LLC · San Diego, CABuilt 1995 · S/N 140 N140SCOrbital Sciences LLC · Mojave, CABuilt 1974 · S/N 193E1067 N14214United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28774 N14219United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28781 N14228United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28792 N14230United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28794 N14231United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28795 N14235United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28947 N14237United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28802

Back to AD 99-23-22 R2