Skip to content

AD 2004-25-16 R1

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.

N7631YMbsp Enterprises Inc · Wilmington, DEBuilt 1965 · S/N 30-707 N7632QPremier Helicopters LLC · Carson City, NVBuilt 1973 · S/N 340-0236 N7632YLee Kitchell · Shelburne Falls, MAS/N 30-709 N7633BSo Cal Leasing LLC · El Cajon, CABuilt 1979 · S/N ME-196 N7633YMatt Younkin Airshows Inc · Siloam Springs, ARBuilt 1965 · S/N 30-710 N7638QGunder Austin C · Red Lion, PABuilt 1971 · S/N 310Q0418 N7638YScientific Motive Systems Inc · Charlevoix, MIBuilt 1965 · S/N 30-717 N7639YCaviris Homestead Farm LLC · Rollinsford, NHBuilt 1965 · S/N 30-718 N763JCPilot Services Of Ohio LLC · Loveland, OHBuilt 1976 · S/N 421C0211 N763MMMerrill Mark · Scottsdale, AZBuilt 1976 · S/N TC-1969 N763RJas & Jls Holdings LLC · Lake Point, UTBuilt 1975 · S/N P351 N7644QSmith Carl D · Durham, NYBuilt 1971 · S/N 310Q0423 N7645YN7645y LLC · Sheridan, WYBuilt 1966 · S/N 30-1236 N7648YFingerlakes Wing And Rotor LLC · Seneca Falls, NYBuilt 1965 · S/N 30-726 N7650FPinnacle Air Charter Inc · Blair, NEBuilt 1976 · S/N 34-7770061 N7651NScarp LLC · Seabrook, TXBuilt 1968 · S/N TC-1148 N7651QAmerican Academy Holdings Inc · Stanford, CAS/N 310Q0430 N7652DGunter Scott · Walters, OKBuilt 1981 · S/N TC-2400 N7652NCockrell Kenneth D · Friendswood, TXBuilt 1968 · S/N TC-1147 N7652QBoone Aviation LLC · Valdosta, GABuilt 1971 · S/N 310Q0431 N7652YMetro West Ambulance · Hillsboro, ORBuilt 1965 · S/N 30-730 N7657NStewart James D · Mesa, AZBuilt 1968 · S/N TC-1130 N7658QRamos Mario · Anaheim, CABuilt 1972 · S/N 310Q0437 N765CFCs Air LLC · Osage Beach, MOBuilt 1987 · S/N TH-1528 N765FLAviation Angel Tours LLC · Beverly Hills, CABuilt 1975 · S/N 414-0644 N765JBN765jb LLC · Colorado Springs, COS/N 340A0647 N765KPMarc Inc · Bolton, MSBuilt 1982 · S/N 31-8253012 N765LTDrj Aviation LLC · Dover, DES/N 340-0181 N765WFKofel Aviation LLC · Clayton, GABuilt 1974 · S/N TH-523 N7661QCooper Kenneth E · Whiting, INBuilt 1971 · S/N 310Q0440 N7664QDluhos Robert A · Hilton Head, SCBuilt 1971 · S/N 310Q0443 N7664YSummit Flight Academy LLC · Peculiar, MOBuilt 1965 · S/N 30-742 N7667QBergenty William F DBA · Plainville, CTBuilt 1972 · S/N 310Q0446 N7668QRiester Robbin W · Navarre, FLS/N 310Q0447 N766AAtp Aircraft 6 LLC · Wilmington, DEBuilt 2007 · S/N 4496245 N766CFAirplane Five LLC · Miami, FLBuilt 1973 · S/N 31-7305102 N7670QRivers Willie G · Atlanta, GABuilt 1972 · S/N 310Q0449 N7671YBailey Wryan T · Nashville, TNBuilt 1965 · S/N 30-749 N7672YBertrand Jason · Seattle, WABuilt 1965 · S/N 30-750 N7674YBooth James R · Nevada City, CABuilt 1965 · S/N 30-752 N7676YCoffman Robert P · Bigfork, MTBuilt 1964 · S/N 30-755 N7678QEshowe Aviation Inc · East Peoria, ILBuilt 1972 · S/N 310Q0457 N767ARMontenecourt Aviation LLC · Wilmington, DEBuilt 1984 · S/N TH-1407 N767AUAuburn University · Auburn, ALBuilt 2019 · S/N 4496456 N767JPPicard Philip A · Clover, SCBuilt 1990 · S/N TH-1583 N767KPPhill-Air Inc · Dover, DEBuilt 1966 · S/N 30-1193 N767PAPurdue Aviation LLC · West Lafayette, INBuilt 2002 · S/N 4496114 N767PEDaytona Aircraft Leasing LLC · Daytona Beach, FLBuilt 1972 · S/N 34-7350042 N767RJS&S Aircraft Inc · Bennington, VTBuilt 1964 · S/N 27-2651 N767SCClegg Stephen A · Port Orange, FLBuilt 1977 · S/N 27-7754060

Back to AD 2004-25-16 R1