Registered aircraft · 1,944

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:95-26-05-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:95-26-05-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:95-26-05-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:95-26-05-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:95-26-05-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:95-26-05-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.

N676MSSky Solutions LLC · Detroit, MIBuilt 2006 · S/N 11482 N678ASBerns James Richard · Old Harbor, AKBuilt 2007 · S/N 11765 N678CPJ&J Holdings And Investments LLC · Phoenix, AZBuilt 2007 · S/N 12074 N678KBSeaton Flying Services · Killeen, TXBuilt 2008 · S/N 1982 N67MFPlay Hard Sports LLC · Wilmington, DEBuilt 2025 · S/N 14825 N67RWStrauss Craig R · Hicksville, NYBuilt 2008 · S/N 12526 N67SBSkyfarm Leasing LLC · Dos Palos, CABuilt 2017 · S/N 14144 N680PMN680pm LLC · Knoxville, IABuilt 1999 · S/N 0680 N681LELeading Edge Aviation Inc · Bend, ORFirst renewal noticeBuilt 2006 · S/N 11211 N681PTRegistered aircraftBuilt 2007 · S/N 11587 N682WCCrown Flight Holdings LLC · Dover, DEBuilt 2025 · S/N 14855 N683RUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 30057 N686AWCyclic LLC · Kalispell, MTBuilt 2005 · S/N 10913 N686BDAshcraft Aviation LLC · Bay City, TXBuilt 2007 · S/N 12075 N688CCRegistered aircraftSale reportedBuilt 2014 · S/N 13638 N689CSAeroav LLC · Tracy, CABuilt 2024 · S/N 14799 N68BEAir Pro Aviation LLC · Cross Lake Twp, MEBuilt 2013 · S/N 2339 N68CGWaterwings Seaplanes LLC · Hoover, ALS/N 11312 N691BARotor Ops 269 LLC · Wilmington, DEBuilt 2006 · S/N 11168 N692BARotor Ops 269 LLC · Wilmington, DEBuilt 2007 · S/N 11980 N695SDDerek Dunn LLC · Levelland, TXBuilt 2007 · S/N 1726 N6960Helifun Expeditions LLC · Kalispell, MTBuilt 2023 · S/N 14632 N696WLKyle Walker Partners LLC · San Antonio, TXBuilt 2021 · S/N 14455 N697RMMile High Rotors Inc · Indian Hills, COBuilt 2015 · S/N 13810 N697SUSouthern Utah University · Cedar City, UTFirst renewal noticeBuilt 2005 · S/N 10736 N698BCButler County Commissioners · Hamilton, OHBuilt 2022 · S/N 14581 N69BKShimek Mark · Port Lavaca, TXBuilt 2002 · S/N 1230 N69BXAustermiller Roger · Mooresville, NCBuilt 2023 · S/N 14648 N69HTTriple Tango LLC · Carlsbad, NMS/N 13894 N69LBCrc Aviation LLC · Leander, TXBuilt 2022 · S/N 14511 N69NSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2012 · S/N 2203 N6HZGrace River Ranch LLC · St Joseph, MOBuilt 2012 · S/N 13287 N6SGCedar Ridge Aviation LLC · Knox City, TXBuilt 2000 · S/N 0878 N6XWLewis Everett D · Comfort, TXFirst renewal noticeBuilt 2005 · S/N 1494 N6YSHawk Aircraft Sales & Leasing LLC · Sterling Heights, MIBuilt 2003 · S/N 1348 N7008NRobinson Helicopter Company Inc · Torrance, CABuilt 1998 · S/N 0464 N700UHAlba Aviation Services · Scottsdale, AZBuilt 2014 · S/N 13696 N70126Ely Ag Services LLC · Sallisaw, OKBuilt 2024 · S/N 14717 N7016GRocky Air LLC · Cheyenne, WYBuilt 2016 · S/N 30008 N7027UTtwn Media Networks LLC · New York, NYBuilt 1998 · S/N 0514 N702CCRpd Enterprises Inc · Nicholson, PABuilt 2002 · S/N 1231 N702TFWhitfield Timothy D · Fairfield, NCS/N 1029 N7030JTtwn Media Networks LLC · New York, NYBuilt 1999 · S/N 0565 N7031VWarren W Wainwright Inc · Merced, CAFirst renewal noticeBuilt 2013 · S/N 13616 N7033EHeritage Construction Co LLC · Austin, TXBuilt 2014 · S/N 13640 N7034JDmp Leasing LLC · Madera, CABuilt 2012 · S/N 13389 N7037CTtwn Media Networks LLC · New York, NYBuilt 1998 · S/N 0469 N703JJJ J Helicopters Inc · Torrance, CABuilt 2006 · S/N 1573 N7040VSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2013 · S/N 2342 N7046GHelo Operations LLC · Waynesville, MOS/N 0541

Back to AD 95-26-05 R1