Skip to content

Registered aircraft · 919

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

N100HJClipper Air Inc · Tomball, TXBuilt 1974 · S/N 340-0334 N10123Sandy Wings LLC · Wilmington, DEBuilt 1971 · S/N 107 N104VVAviation Trust Company LLC Trustee · Oklahoma City, OKS/N 53 N105RHJem Aviation Solutions LLC · South River, NJBuilt 1984 · S/N 650-0055 N105TBAir Force Material Command Esc/Dikl · Hanscom Afb, MABuilt 1968 · S/N 31 N106PGGreco Equipment Leasing LLC · Bartlett, ILBuilt 1993 · S/N 650-7012 N108BKKent Aviation LLC · Midland, TXBuilt 2001 · S/N 305 N109BGAviation Leasing Group Inc · Wilmington, DEBuilt 1982 · S/N NA0310 N109CBSasser Edward Craig · Albemarle, NCBuilt 1975 · S/N 340-0533 N109SBSabre Direct · Chicago, ILS/N 380-20 N10TNPacific Rim Management LLC · Downey, CAS/N 257085 N10XEBlaikie Thomas B · Kenner, LABuilt 1973 · S/N 340-0221 N111FFabair LLC · Milwaukee, WIBuilt 1991 · S/N 650-0197 N111GTMorgan Gerald W · Hillsboro, TXS/N 340-0188 N111YWN111yw LLC · Houston, TXBuilt 1993 · S/N 650-0223 N11288Fly The Coop Aviation LLC · Willow Park, TXBuilt 1990 · S/N 650-0184 N112EDE D Santos & Associates LLC Trustee · Wilmington, DES/N 258048 N116EALewistown Aviation Inc · Lewistown, PABuilt 1979 · S/N 340A0750 N116MBTvpx Ars Inc Trustee · North Salt Lake, UTS/N 650-7081 N117BGJohnson Calvin · Fort Lauderdale, FLBuilt 1983 · S/N 650-0007 N117HHZephyr Air LLC · Houston, TXBuilt 1993 · S/N 258249 N117JTColcot Aviation LLC · New York, NYBuilt 1992 · S/N 258205 N118CDFirst Aviation Service Corp · Wilmington, DEBuilt 1977 · S/N NA0212 N118JKRegistered aircraftBuilt 1984 · S/N 445 N118MMBradley Flight LLC · Denver, COBuilt 1999 · S/N 650-7105 N119URegistration Pending · South Portland, MERegistration pending, canceledBuilt 1992 · S/N 259007 N11LXN492a LLC · Goodyear, AZBuilt 1974 · S/N 306-75 N120HL4e Holdings LLC · Milwaukee, WIBuilt 1988 · S/N 120.111 N1210LElite Elevated Enterprises LLC · Las Vegas, NVBuilt 1997 · S/N 650-7078 N121CZN121cz LLC · Milwaukee, WIBuilt 1999 · S/N 120350 N122HL4e Holdings LLC · Milwaukee, WIBuilt 1993 · S/N 120271 N122LJBas Part Sales LLC · Greeley, COBuilt 1993 · S/N 258239 N123AMC W Myers Holdings LLC · Anthony, NMBuilt 1973 · S/N 340-0245 N123HKTavaero Jet Charter Corp · Houston, TXBuilt 1992 · S/N 258208 N124DRLeventis Phil P · Sumter, SCBuilt 1973 · S/N 340-0219 N124HBVanguard Aircraft Trust Company LLC Trustee · Fort Lauderdale, FLBuilt 1996 · S/N 650-7067 N124HL4e Holdings LLC · Milwaukee, WIBuilt 1994 · S/N 120.284 N125CPLinscott Jeffrey R · Boring, ORBuilt 1972 · S/N 340-0093 N125CZN125cz LLC · Milwaukee, WIBuilt 1994 · S/N 120.290 N125SBBay Venture Management LLC · Atlanta, GABuilt 1985 · S/N 258046 N125TNTriad Aviation LLC · Tyler, TXBuilt 1993 · S/N 650-7025 N126CZN126cz LLC · Milwaukee, WIBuilt 1996 · S/N 120.308 N127CZN127cz LLC · Milwaukee, WIBuilt 1999 · S/N 120353 N127GKAlliance Aviation Group LLC · Wilmington, DES/N 311 N128HL4e Holdings LLC · Milwaukee, WIBuilt 1999 · S/N 120351 N129CZN129cz LLC · Milwaukee, WIBuilt 1993 · S/N 120.270 N129GBCapital Cost Corp · Wilmington, DEBuilt 1983 · S/N 650-0006 N12SYMcwalsh LLC · Dover, DEBuilt 1987 · S/N 258103 N131FLIfl Group Inc · Waterford, MIBuilt 1955 · S/N 155 N131PGAga Aviation LLC · Lewes, DEBuilt 1986 · S/N 650-0126

Back to AD 96-25-12