Registered aircraft · 10,537

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.

N14CEFacility Concepts Developments LLC · Jackson, MSBuilt 1989 · S/N TH-1562 N14FPBakowicz John R · Sunbury, PABuilt 1974 · S/N 34-7450096 N14FZWurzer Frank · Tallmadge, OHBuilt 1978 · S/N 34-7870122 N14GSKerner Robert · La Vergne, TNBuilt 1971 · S/N 27-4637 N14JDC340-340 LLC · Pinckney, MIBuilt 1974 · S/N 340-0340 N14JHRegistered aircraftBuilt 1998 · S/N TH-1845 N14JNNational Test Pilot School · Mojave, CABuilt 1975 · S/N 34-7570254 N14MCBlue Skies Blue Water LLC · Henderson, NVBuilt 1964 · S/N 320C0008 N14MRMarlin Aviation Flying Service LLC · West Palm Beach, FLBuilt 1972 · S/N 33701459 N14NESchroeder David C · Norfolk, NEBuilt 1984 · S/N 31T-1104012 N14PGorman Aviation LLC · Bartlesville, OKBuilt 1985 · S/N TJ-492 N14RTSierra Ae LLC · Wilmington, DEBuilt 1974 · S/N 421B0640 N14SSBas Part Sales LLC · Greeley, COS/N 34-7770385 N14TNGonzalez-Ruiz Antonio R · Mountain Brk, ALBuilt 1981 · S/N 31T-8120060 N14UAMilam Equipment LLC · Trussville, ALS/N 414-0605 N14XMMedical Diagnostic Imaging Inc · Sacramento, CABuilt 1976 · S/N TH-758 N15008Wings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 34-7250346 N1500G5 Lg LLC · Rome, GABuilt 1975 · S/N 414-0814 N1500LLandolt Gregg E · Moreno Valley, CABuilt 1968 · S/N TC-1120 N15018N15018 LLC · Sanger, TXBuilt 1972 · S/N 34-7250347 N15024Whytes Inc · Coconut Creek, FLBuilt 1972 · S/N 34-7250349 N15035Wings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 34-7250353 N15064Kropp Christian Owner Trustee · Azle, TXS/N 34-7350005 N15089Tusla Technology Center School District #18 · Tulsa, OKS/N 34-7350018 N150CFDesutter S Bryan · Manito, ILBuilt 1980 · S/N 340A1215 N150PFParagon Flight Training Co · Fort Myers, FLBuilt 2022 · S/N 4496545 N1510GGmr Leasing LLC · Lincoln, DEBuilt 1974 · S/N 421B0606 N1511WFlorida Float Plane LLC · Coral Gables, FLBuilt 1972 · S/N TH-217 N15145Tri-Star Aviation Inc · La Porte, TXBuilt 1972 · S/N 34-7350026 N1515WCenturionair LLC · Greenville, SCBuilt 1972 · S/N TH-218 N1519THigh Flyers Aviation Services LLC · Gaithersburg, MDBuilt 1972 · S/N 34-7250337 N151FClark Robert G · Healdsburg, CABuilt 1964 · S/N TC-613 N151STWildman Lake Lodge Inc · Anchorage, AKBuilt 1979 · S/N 31-8052036 N15215Curtis David W · Watertown, NYBuilt 1972 · S/N 34-7350036 N1526MGarmin At Inc · Salem, ORBuilt 1994 · S/N TH-1711 N1527GHanley Thomas W · Kissimmee, FLBuilt 1974 · S/N 421B0623 N1529SRich Aviation Services LLC · Fort Worth, TXBuilt 1963 · S/N TC-528 N152BGBlossman Gas Of North Carolina Inc · Swannanoa, NCBuilt 1976 · S/N TC-2015 N152TATuck Aerial Surveys Inc · Big Stone Gap, VAS/N 20800664 N152URoyal Air Inc · Shreveport, LABuilt 1968 · S/N P-14 N1532XRaymond Darwin V · Glenwood Springs, COBuilt 1975 · S/N 34-7570275 N1533EPhoenix East Aviation LLC · Daytona Beach, FLS/N 34-7350050 N1534GRugger Investment Group LLC · Tustin, CAS/N 421B0630 N1536XClark Christopher · Ormond Beach, FLBuilt 1975 · S/N 34-7570276 N153EJQualitair LLC Trustee · MichelstadtBuilt 1983 · S/N 31P-8414011 N153LMSkylens LLC · Hammond, LABuilt 1976 · S/N 27-7754019 N153WBOster Dale E · Trego, MTBuilt 1966 · S/N 27-3329 N1543GQds Aviation LLC · Baton Rouge, LABuilt 1974 · S/N 421B0639 N1545WM T Air LLC · Olive Branch, MSBuilt 1989 · S/N TH-1545 N1549TPalmer Jonathan L · The Woodlands, TXBuilt 1973 · S/N 310Q0755

Back to AD 2004-25-16 R1