Registered aircraft · 896

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-15-04-R1') 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-15-04-R1') 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-15-04-R1')
    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-15-04-R1')
  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-15-04-R1')
  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-15-04-R1')
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.

N43CHMatus Richard J · Fort Worth, TXBuilt 1994 · S/N 4622176 N440GTOlufsen Niels · Lakeway, TXBuilt 2006 · S/N 4636399 N4421RJ & B Aircraft Leasing LLC · Lufkin, TXBuilt 1985 · S/N 46-8508051 N4428LAltenpohl LLC · High Point, NCBuilt 2014 · S/N 4636628 N4429FMc Leasing LLC · Delta, UTBuilt 2014 · S/N 4636644 N44463Sabine Financial Services Inc · Wilmington, DEBuilt 1988 · S/N 4608113 N444DTBagdasarian Walter DBA · El Cajon, CAS/N 4608008 N445MAPvl Development LLC · Nashville, TNBuilt 2008 · S/N 4636442 N446JCSaf Aviation LLC · Lakewood Ranch, FLBuilt 2022 · S/N 4636806 N446MMInternational Air Services Inc Trustee · Carson City, NVS/N 4608006 N446NCKhk Management Services LLC · Norcross, GABuilt 2010 · S/N 4636469 N447DLGlobal Control Systems Inc · Olathe, KSBuilt 2008 · S/N 4636436 N447SCN447sc LLC · Carmel, CABuilt 1989 · S/N 4622074 N448STJames David W · Odessa, TXBuilt 2008 · S/N 4636448 N449MMLaxson William W Jr · Anchorage, AKBuilt 2019 · S/N 4636742 N44GWReed Aviation LLC · Williamsport, PABuilt 2000 · S/N 4636276 N44HALaps LLC · Elkhorn, WIBuilt 1984 · S/N 46-8408026 N451MAUpward Aviation LLC · Bridgeville, DEBuilt 2012 · S/N 4636541 N451SPSacramento International Jet Center Inc · Sacramento, CABuilt 2003 · S/N 4636345 N455TWTd Air LLC · Cannon Beach, ORBuilt 2001 · S/N 4636323 N456BKSky West Aviation Inc Trustee · Albuquerque, NMS/N 4636381 N456EASpasco LLC · Helena, MTBuilt 1989 · S/N 4622042 N458KDTvpx Trust Co LLC Trustee · North Salt Lake, UTS/N 4636762 N460WWMalibu Ww LLC · Fayetteville, GABuilt 1986 · S/N 46-8608022 N461DKMark Andregg Dds Pc · Tulsa, OKBuilt 1985 · S/N 46-8508102 N461SBHeathman Planting Co · Indianola, MSBuilt 2012 · S/N 4636525 N461TBTambry Ventures LLC · Happy Valley, ORBuilt 2010 · S/N 4636473 N461TMSpearman Michael · The Woodlands, TXBuilt 1984 · S/N 46-8408050 N461VFFlight International Corp Trustee · Flagstaff, AZS/N 46-8408049 N462HPPrescott Healthcare LLC · Prescott, AZBuilt 2000 · S/N 4636285 N462LTSilber Justin A · Atlanta, GABuilt 1996 · S/N 4636056 N462TMPalisades Creek Aircraft Co LLC · Thayne, WYBuilt 1989 · S/N 4622029 N463AMOcean Aviation Holdings LLC · Miami Gardens, FLBuilt 1977 · S/N 4636770 N463HPBas Part Sales LLC · Greeley, COBuilt 2002 · S/N 4636335 N463JPJj Hughes Logistics LLC · Canyon, TXBuilt 1999 · S/N 4636216 N463KCCalm Air Aviation LLC · Norfolk, NEBuilt 2007 · S/N 4636412 N464JBHhi Aviation Inc · Newark, DEBuilt 1999 · S/N 4636199 N464JFK&G Bell LLC · Albuquerque, NMBuilt 2019 · S/N 4636752 N464LBPlane Austin LLC · Sherwood, ORBuilt 1993 · S/N 4622139 N464SMB&S Investments · Hereford, TXS/N 4636464 N4694ZKyro Consulting LLC · Williamsburg, VABuilt 1988 · S/N 4608115 N469HPTrussell David · Fremont, CABuilt 1985 · S/N 46-8508109 N46CRBas Part Sales LLC · Greeley, COBuilt 1986 · S/N 46-8608021 N46EHStar H Aviation LLC · Plano, TXBuilt 1988 · S/N 4608108 N46GTMitchell Investment Research LLC · San Dimas, CABuilt 2019 · S/N 4636760 N46JCAdventures Air Express LLC · Malabar, FLBuilt 1997 · S/N 4636125 N46JKJm Aircraft Inc · Hickory, NCS/N 4608105 N46KCSandbox Holdings LLC · Missoula, MTBuilt 2019 · S/N 4636746 N46KJK-A Mirage LLC · Winnetka, ILBuilt 1996 · S/N 4636037 N46LAMagoon Paul J · Merrimack, NHBuilt 1986 · S/N 46-8608055

Back to AD 99-15-04 R1