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.

N250DFDmfs Leasing LLC · Des Moines, IABuilt 2026 · S/N 4636878 N25120Waconda Concepts LLC · Sturgis, SDBuilt 1985 · S/N 46-8508097 N2529XCpdl Pm LLC · Dallas, TXBuilt 2012 · S/N 4636553 N252MJThorpe Curtis D · Fredericksburg, TXBuilt 2012 · S/N 4636548 N253HLIscil Kaan · Miami, FLBuilt 2021 · S/N 4636779 N253MAHoosier Doc LLC · South Bend, INFirst renewal noticeBuilt 2004 · S/N 4636353 N2545HNoble Aviation Enterprises LLC · Phoenix, AZBuilt 2012 · S/N 4636561 N254HTFly254 LLC · Waco, TXBuilt 1993 · S/N 4622127 N2569YDavidson James E · Bothell, WAS/N 46-8508104 N257LGClear Sky Aviation LLC · Coral Springs, FLS/N 46-36066 N25906Valiair Limited Co Trustee · Casper, WYBuilt 2013 · S/N 4636590 N2591BDevries Larry E · Pella, IABuilt 2013 · S/N 4636583 N2592YValiair Lc Trustee · Casper, WYBuilt 2013 · S/N 4636592 N25CXVisair II LLC · Canton, OHBuilt 1985 · S/N 46-8508100 N25LHCole Aviation LLC · Wichita, KSBuilt 1985 · S/N 46-8508070 N25PFCloud Tops LLC · Mclean, VABuilt 1998 · S/N 4636162 N26030Lessing Aviation LLC · Denver, COBuilt 1985 · S/N 46-8508107 N261NMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 4636671 N268RPTag Ag 04 LLC · Richmond, TXBuilt 2011 · S/N 4636511 N269R219 Air LLC · South Bend, INBuilt 1986 · S/N 8608065 N26PGSan Angeles Aviation LLC · Phoenix, AZFirst renewal noticeBuilt 1990 · S/N 4622117 N26TGKenmore Crew Leasing Inc Trustee · Bellingham, WAFirst renewal noticeBuilt 1999 · S/N 4636193 N274CFair18 LLC · Montgomery, ALBuilt 2013 · S/N 4636578 N276JKGfk Investments LLC · Saint Joseph, MIS/N 4636520 N27RZHq Wings LLC · Porterville, CAS/N 4636299 N2808LNtss LLC · Henderson, NVBuilt 2015 · S/N 4636676 N280KCMccarty Anthony O · Saint Augustine, FLBuilt 1999 · S/N 4636219 N280KTGetchell Investments LLC · Dallas, TXBuilt 2002 · S/N 4636329 N283SSSmith Scott R · Grand Junction, COBuilt 1997 · S/N 4636080 N286CMB&K Aircraft Leasing LLC · West Plains, MOBuilt 1986 · S/N 46-8608043 N288TGSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2015 · S/N 4636682 N28BRFlying Rock Aero LLC · Sunnyvale, CABuilt 1986 · S/N 468608045 N28JKTorps LLC · Southlake, TXBuilt 1998 · S/N 4636164 N28KYSoldo Joseph Peter · Chattanooga, TNBuilt 1984 · S/N 468508015 N295SKds Aviation LLC · Normal, ILS/N 4636174 N297CLivestock Health Products-Texas Inc · Dalhart, TXBuilt 2004 · S/N 4636359 N297PMCentral City Aviation LLC · Carrington, NDBuilt 1997 · S/N 4636101 N29KETj Air Holdings Inc Trustee · Wilmington, DEBuilt 2004 · S/N 4636352 N304LAK2 Sales LLC · Idaho Falls, IDS/N 4622033 N306YSFlamingo Aircraft Holdings LLC · Orlando, FLBuilt 2024 · S/N 4636850 N3098NValiair Lc Trustee · Casper, WYBuilt 2004 · S/N 4636357 N309HWWolfe Rentals LLC · Milwaukie, ORBuilt 2013 · S/N 4636612 N310BUTar Heel Aviation Inc · Bonita Springs, FLBuilt 1986 · S/N 4608004 N310EMTc Aviation LLC · Atlanta, GABuilt 1988 · S/N 46-08109 N311JFGrowers LLC · Mohall, NDS/N 4622039 N311KFAlpha Papa LLC · Fort Stockton, TXBuilt 1999 · S/N 4636194 N311LGCorporate Aviation Partners I LLC · Fort Worth, TXBuilt 2025 · S/N 4636866 N3131MAir Service LLC · Wilmington, DEBuilt 2006 · S/N 4636382 N314PLWkj Enterprises LLC · Boulder, COBuilt 2011 · S/N 4636521 N3151GMtc Aviation LLC · New Harmony, UTS/N 4636390

Back to AD 99-15-04 R1