Registered aircraft · 16,280

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:2008-06-28-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:2008-06-28-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:2008-06-28-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:2008-06-28-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:2008-06-28-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:2008-06-28-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.

N782LULiberty University School Of Aeronautics · Lynchburg, VABuilt 2014 · S/N 4496372 N782MFWallace State Community College · Hanceville, ALBuilt 2023 · S/N 28020122 N782NDFox Leasing Group LLC · Hollywood, FLBuilt 2016 · S/N 4496397 N782PGUltimax Aviation LLC · Columbus, OHS/N 3204 N782SRN782sr LLC · Missoula, MTBuilt 2007 · S/N 2884 N782YLLift And Thrust LLC · Chicago, ILS/N 441-0339 N783ABDelta Sr Nc LLC · Raleigh, NCBuilt 2025 · S/N 10557 N783CDSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2005 · S/N 1573 N783JMTime Machine LLC · Newton, ILBuilt 2018 · S/N 4635 N783KAKalex Enterprises Inc · Kingston, MABuilt 2024 · S/N 10298 N783LAN783la LLC · Philadelphia, PABuilt 2025 · S/N 28020215 N783LULiberty University School Of Aeronautics · Lynchburg, VABuilt 2015 · S/N 4496381 N783LXGenetech Animal Reproduction LLC · Purcell, OKBuilt 2021 · S/N 5097 N783NDVertol Systems Company Inc · Destin, FLBuilt 2016 · S/N 4496398 N783RJMlc Aviation LLC · Sewickley, PABuilt 2015 · S/N 4291 N783SRZarate LLC · Miami, FLBuilt 2007 · S/N 2783 N783WMBoard Of Trustees Of Western Michigan University · Kalamazoo, MIBuilt 2024 · S/N 10115 N7840FLederach David B · Bethlehem, PABuilt 1976 · S/N 28-7790228 N7848CZeitler Christopher · Middleton, WIBuilt 1975 · S/N 28-7690085 N784CValiair Limited Company Trustee · Casper, WYBuilt 2013 · S/N 4636584 N784CAEagle Capital Holdings LLC · Doylestown, PABuilt 2026 · S/N 11101 N784CDRay Matthew C · Powell, OHS/N 1700 N784DSErina Aviation LLC · Sunnyvale, CABuilt 2021 · S/N 2672 N784LAN784la LLC · Philadelphia, PABuilt 2025 · S/N 28020216 N784LULiberty University School Of Aeronautics · Lynchburg, VABuilt 2016 · S/N 4496396 N784RRInarayan Aviation LLC · Orlando, FLBuilt 1979 · S/N 441-0078 N7853CDue West Aviation LLC · Brandon, SDBuilt 1975 · S/N 28-7690086 N7855LJrm Equipment LLC · San Francisco, CABuilt 2006 · S/N 1951 N7855ZRoskowski David · Charlestown, INBuilt 2005 · S/N 1629 N785BBWarehouse #41 LLC · Wake Forest, NCBuilt 2023 · S/N 9429 N785CDPresidio LLC · Manhattan, KSBuilt 2005 · S/N 1718 N785HCKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1999 · S/N 4636206 N785LAN785la LLC · Philadelphia, PABuilt 2025 · S/N 28020217 N785LULiberty University · Lynchburg, VABuilt 2018 · S/N 4496433 N785MXtwa Cirrus LLC · Rio Verde, AZBuilt 2023 · S/N 9471 N785NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2016 · S/N 4496399 N785RMJesnet Aviation LLC · Sanford, FLBuilt 1986 · S/N 28-8616057 N785WCWillwork 4 Jeta LLC · Houston, TXBuilt 1978 · S/N BB-425 N786AAtp Aircraft 2 LLC · Wilmington, DEBuilt 1997 · S/N 4496016 N786AMCenter For Healthcare Education Inc · Riverside, CAS/N 40.726 N786ARRiley Cord · Hindsville, ARBuilt 2006 · S/N 1837 N786EHJoey Air LLC · Laguna Beach, CABuilt 2023 · S/N 9445 N786FBEagle Aviation LLC · Indianapolis, INBuilt 2024 · S/N 28020176 N786HPHudson Pro Aviation LLC · Hoboken, NJBuilt 2020 · S/N 4968 N786JBInnovative Trailer Mfg Inc · Richfield, UTBuilt 2014 · S/N 4034 N786MDBas Part Sales LLC · Greeley, COBuilt 1998 · S/N 4636156 N786MSKing Kimberly A · Kensington, NHBuilt 1999 · S/N 3449114 N786RASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2009 · S/N 3552 N786WBFuzzy Whiz LLC · Fairfax, VABuilt 2020 · S/N 4963 N7871XCirrus Design Corp · Duluth, MNS/N 11732

Back to AD 2008-06-28 R1