Registered aircraft · 10,536

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:2004-25-16-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:2004-25-16-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:2004-25-16-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:2004-25-16-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:2004-25-16-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:2004-25-16-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.

N1093GLombard William E · Bellingham, WABuilt 1996 · S/N TH-1793 N1094GOgan Michael J · Pierre, SDBuilt 1996 · S/N TH-1794 N109CBSasser Edward Craig · Albemarle, NCBuilt 1975 · S/N 340-0533 N109CCTrans-Caribbean Air Exp & Imp Inc · Miami, FLBuilt 1968 · S/N 27-4024 N109DWAero East USA LLC · Portage, INBuilt 1976 · S/N TJ13 N109FCUsda Forest Service Fepp · Tallahassee, FLBuilt 1980 · S/N 31-8012073 N109WESpace Coast Aircraft Co · Merritt Island, FLBuilt 1978 · S/N 347870405 N10AAPeterson Andrew · Louisville, KYBuilt 1966 · S/N 320E0046 N10BBFayard Enterprises LLC · Wake Forest, NCBuilt 1989 · S/N 20800152 N10BNBlack Thomas D DBA · Clearwater, FLBuilt 1975 · S/N 34-7570050 N10DRFlying W LLC · Camden, DEBuilt 1994 · S/N 3448044 N10ETTech Nav LLC · Columbus, INBuilt 1971 · S/N 310Q0415 N10FCKnott Me LLC · Phoenix, AZBuilt 1973 · S/N 310Q0796 N10FFValiair Lc Co Trustee · Casper, WYBuilt 1976 · S/N 421C0082 N10KMJohnson Walter N · Hico, TXS/N 310I0101 N10NFThompson Benjamin K · Nevada, TXBuilt 1976 · S/N TJ-64 N10NZConnor Reginald W · The ValleyNon-citizen corporation, flight hours not reportedS/N 34-7870158 N10PBNeves Frank Jr · North Miami Beach, FLBuilt 1974 · S/N 34-7570031 N10PRVillalobos Jesus F · Farmington, NMBuilt 1961 · S/N 310-0032 N10QBAsc Aviation LLC · Brandon, MSBuilt 1978 · S/N 31-7812065 N10WPawsitive Rate LLC · Corpus Christi, TXBuilt 1984 · S/N TJ-448 N10XEBlaikie Thomas B · Kenner, LABuilt 1973 · S/N 340-0221 N10YCToyz Aviation LLC · Worthington, KYBuilt 1979 · S/N 31-8012002 N10YDDavenport Jimmy J · Hayesville, NCBuilt 1965 · S/N 27-2892 N10YPBmf Jax LLC · Jacksonville, FLBuilt 2020 · S/N 20800666 N1100LRaider Aviation LLC · Lubbock, TXS/N 30-12 N1103QHenderson Phillip Kimon III · Benton Harbor, MIBuilt 1963 · S/N 310H0103 N1105QSundale Aviation Inc · Erwinna, PABuilt 1963 · S/N 310H0105 N1106QOrellana Wilson · Hesperia, CAS/N 310H0106 N1106XVan Vleet Merlin D · Kingman, AZBuilt 1975 · S/N 34-7570212 N1107QValiair Limited Co Trustee · Casper, WYBuilt 1963 · S/N 310H0107 N1109MPatrick Chris J · Paris, ILBuilt 1970 · S/N 33701309 N110CAFargo Jet Center LLC · Fargo, NDBuilt 1975 · S/N 34-7570219 N110CSFlorida Keys Flight Academy LLC · Marathon, FLBuilt 1972 · S/N 310Q0616 N110CWMile High 1 LLC · Lakeway, TXBuilt 1980 · S/N TK-115 N110DHYingling Consultation LLC · Wilmington, DES/N 421B0137 N110FBElon Aviation LLC · Burlington, NCBuilt 1976 · S/N TC-2024 N110GGSkyview Aviation LLC · Tracy, CABuilt 2024 · S/N 3449486 N110LLFlight Level 7 Inc · Wilmington, DEBuilt 1971 · S/N 39-89 N110MJTuggle Jason C · Liberty Hill, TXBuilt 1975 · S/N 34-7570117 N110NPJungemann Jeff D · Brigham City, UTBuilt 1973 · S/N 33701565 N110RVMillspaugh John · Weatherford, OKBuilt 1981 · S/N 34-8133196 N110SMPenhall Michael Joseph · Lake Forest, CABuilt 1964 · S/N 337-0023 N110SUAri Ben Aviator Inc · Fort Pierce, FLBuilt 1978 · S/N ME-81 N110VEHorizon Group Inc Trustee · Boca Raton, FLBuilt 1977 · S/N 414A-0017 N110WWTorba Jacob · Citrus Heights, CABuilt 1969 · S/N 30-1846 N1111HBielamowicz John Kolbe · Waxahachie, TXBuilt 1964 · S/N 30-427 N1112JJedco Properties LLC · Ruston, LABuilt 1997 · S/N TH-1822 N1112QLastowski Gerald J · Gulf Breeze, FLBuilt 1963 · S/N 310H0112 N1113XRegistered aircraftBuilt 1997 · S/N TH-1813

Back to AD 2004-25-16 R1