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.

N752CFAnytime Flights LLC · Scottsdale, AZBuilt 1964 · S/N 30-592 N7531QSantiago Jose G Jr · Woodstock, GABuilt 1969 · S/N 310Q0031 N7533YFlying Pirates Unlimited LLC · New Bern, NCBuilt 1964 · S/N 30-596 N7535YN7535y LLC · Sylvania, OHBuilt 1964 · S/N 30-598 N7537QRegistration Pending · Defiance, OHRegistration pending, pending cancellationBuilt 1970 · S/N 310Q0037 N7537YCecerr Paul E · Olive Branch, MSS/N 30-601 N7538YEdwards John G · Stoneville, NCBuilt 1964 · S/N 30-602 N75391Brennan Matthew J · Loveland, OHBuilt 1976 · S/N 34-7670246 N7539YChristianini Cassio Pereira · Plantation, FLBuilt 1964 · S/N 30-603 N753DMAcid And Cementing Inc · Palestine, TXBuilt 2002 · S/N TH-2047 N7542YLyle Eugene W · Honesdale, PABuilt 1965 · S/N 30-606 N7546YBrilliant Holdings LLC · Winfield, MOBuilt 1965 · S/N 30-609 N7549QAlford Air Transportation LLC · Kernersville, NCBuilt 1972 · S/N 421B0341 N754JSDy34 LLC · Adamsville, TNBuilt 1975 · S/N 414-0643 N754KCPlane Crazy Aviation LLC · Fargo, NDBuilt 1981 · S/N 414A0803 N7551YWills Terry W · Cedar Park, TXBuilt 1964 · S/N 30-614 N7552QTaylor Randy L · Upland, CABuilt 1969 · S/N 310Q0052 N7554QSky Farmer LLC · Culleoka, TNBuilt 1970 · S/N 310Q0054 N7555YHirvonen Jukka Matti · Oak Ridge, NCBuilt 1964 · S/N 30-618 N7557QCircle C Aviation LLC · Orlando, FLBuilt 1972 · S/N 421B0345 N755BABeek Nigel A · Pembroke Pines, FLBuilt 1974 · S/N TC-1699 N755BCMav Management LLC · Rockledge, FLBuilt 1978 · S/N 421C0497 N755GHJeff Hux Farms LLC · Sikeston, MOBuilt 1997 · S/N TH-1838 N7560YRa Procurement LLC · Maypearl, TXBuilt 1964 · S/N 30-623 N7561YStinson Aviation LLC · Middletown, DEBuilt 1964 · S/N 30-624 N7562YOtten John P · Lingle, WYBuilt 1964 · S/N 30-625 N7564QFairchild Chad E · Logandale, NVBuilt 1970 · S/N 310Q0064 N7565YVictor Robert W Jr · Topeka, KSBuilt 1964 · S/N 30-629 N7566YS & D Adventure LLC · Middletown, DEBuilt 1964 · S/N 30-630 N7568QJughead Aircraft LLC · Salina, KSBuilt 1970 · S/N 310Q0068 N756AAtp Aircraft 6 LLC · Wilmington, DEBuilt 2007 · S/N 4496244 N7571YPipers Are Still Better LLC · Carson City, NVBuilt 1964 · S/N 30-636 N7572YBlack And Faraday Inc · Pencil Bluff, ARS/N 30-637 N7573YLawrence Earl A · Alexandria, VABuilt 1964 · S/N 30-638 N7574YWdc Aviation LLC · Williamsburg, VABuilt 1964 · S/N 30-640 N7576YJ & P Toys Inc · Fort Myers, FLBuilt 1968 · S/N 27-4076 N7577YN1245d LLC · Wilmington, DEBuilt 1964 · S/N 30-643 N757DBAviation Investments Inc · Virginia Beach, VABuilt 1977 · S/N TC-2013 N757PABmr Financial Inc · Kingston Springs, TNBuilt 1982 · S/N TH-1333 N757RHPanther Partnership Equipment I LLC · Gibsonton, FLS/N 421C1049 N7583YMege Ronald W · Port Jervis, NYS/N 30-649 N7584DBuehler Benjamin M · Issaquah, WAS/N P-180 N7586QTyler Rdh Investments LLC · Tyler, TXBuilt 1970 · S/N 310Q0086 N7587DCelco Co · Mahwah, NJBuilt 1971 · S/N P-181 N7588YK&Cs Saveacomanche LLC · Spring Lake Park, MNBuilt 1964 · S/N 30-655 N7589QTemptation Motors Ltd · Hayward, CABuilt 1970 · S/N 310Q0089 N758ASRff Aviation LLC · Mount Clemens, MIBuilt 2000 · S/N 3449187 N758BLSouther Field Aviation Inc · Americus, GAS/N 34-7350318 N758CG Daniel Evans P C · Birmingham, ALBuilt 1981 · S/N TH-1275 N758CAAccess Denied Inc · Wilmington, DEBuilt 1978 · S/N TH-1001

Back to AD 2004-25-16 R1