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.

N824PGMount Olive Flight Club LLC · Mount Olive, NCBuilt 1982 · S/N 31-8252055 N824RBShark Water Systems LLC · Hobbs, NMBuilt 1979 · S/N 414A0411 N8250DCasavannah Aviation LLC · Clearwater, FLBuilt 1980 · S/N 34-8070330 N8250YStoltz Kevin · Locust Grove, GABuilt 1966 · S/N 30-1376 N8252BPelican Holdings LLC · Block Island, RIBuilt 1980 · S/N 34-8070333 N8252GJb Flight LLC · Indianapolis, INBuilt 1982 · S/N 34-8233179 N8253HAom Aircraft LLC · Orlando, FLBuilt 1980 · S/N 34-8070335 N8253PNea Aviation LLC · Gadsden, ALBuilt 1980 · S/N 34-8070337 N82549Airgo Incorporated · Centralia, ILS/N 44-8107015 N8254EPerfect Agreements Leasing · Trabucco Canyon, CABuilt 1980 · S/N 44-8107014 N8254YCrimson Aviation LLC · Helena, MTBuilt 1966 · S/N 30-1380 N8256YPhill-Air Inc · Dover, DEBuilt 1967 · S/N 30-1382 N8257HS And G Ventures LLC · Wilmington, DEBuilt 1992 · S/N TH-1650 N8258YJohnson David C · Chisago City, MNBuilt 1966 · S/N 30-1384 N8259YRyan Ferguson LLC · Sanford, FLBuilt 1966 · S/N 30-1386 N825AJJarvis Jayson S · Pinehurst, NCBuilt 1977 · S/N TC-2050 N825FGN825fg Corp Trustee · Wilmington, DES/N 34-7350303 N825GSRed River Ranch LLC · Wilmington, DEBuilt 1972 · S/N 310Q0510 N825WBeckett Jesse · Lakeway, TXS/N 340A0728 N8261URodriguez Nat III · Odessa, TXBuilt 1980 · S/N 34-8070351 N8261YWilliams Brannon R · Fort Worth, TXBuilt 1966 · S/N 30-1388 N8262YAchamp LLC · Memphis, TNBuilt 1966 · S/N 30-1390 N8263MKent State University · Stow, OHBuilt 1981 · S/N 44-8195026 N8264FRick Aviation Inc · Newport News, VABuilt 1980 · S/N 44-8107027 N8264YPatterson Casey Paul · Kinston, ALBuilt 1966 · S/N 30-1392 N8266YWerner Thomas E · Newark, DEBuilt 1966 · S/N 30-1394 N8267YMh Aviation Inc · Lancaster, CABuilt 1966 · S/N 30-1395 N8268YBas Part Sales LLC · Greeley, COBuilt 1966 · S/N 30-1397 N8269TUniversal Aviators Academy Inc · El Monte, CABuilt 1980 · S/N 44-8107022 N826ATAviation Training LLC · Wilmington, DEBuilt 2002 · S/N 4496148 N826CMKuriel Michael · Las Vegas, NVS/N 421C0508 N826MTG T Acft Inc · Franklin Square, NYBuilt 1979 · S/N TK-109 N826VGA Bit Extra LLC · River Ridge, LABuilt 1975 · S/N 34-7570218 N8271YWhitley Miles G · Olathe, KSBuilt 1966 · S/N 30-1400 N8272BAndy-Oxy Co Inc · Asheville, NCBuilt 1990 · S/N TH-1601 N8273YSkyway Air Service Inc · Wichita, KSBuilt 1966 · S/N 30-1402 N8274YTwinkie Transport LLC · Palm City, FLBuilt 1966 · S/N 30-1403 N8276ASt Cloud Technical & Community College · Saint Cloud, MNBuilt 1980 · S/N 44-8107023 N8278TRegistered aircraftBuilt 1992 · S/N TH-1672 N827ADFly By Knight Inc · Hammond, LABuilt 1979 · S/N 34-7970317 N827ATAviation Training LLC · Wilmington, DEBuilt 2002 · S/N 4496149 N827DBHigh Sky Aviation Inc · Wauchula, FLBuilt 2003 · S/N 3449276 N827EBEbor Management Inc · Alpharetta, GABuilt 1970 · S/N TH-135 N827ECPacific Fleet Aviation LLC · Rochester, NYBuilt 1980 · S/N 27-8154005 N827LPSagamore Aviation LLC · Lewes, DES/N 31T-7904048 N827RDGoyo Air LLC · Miami, FLBuilt 1976 · S/N 31-7652094 N827TSCurless Harley · Havana, ILBuilt 1977 · S/N TH-836 N827VU827vu LLC · Au Gres, MIS/N TC-2104 N82818Miller Bryan D · Tampa, FLBuilt 1980 · S/N 34-8070263 N8286YCoub Industries Inc · Fairfield, CABuilt 1967 · S/N 30-1422

Back to AD 2004-25-16 R1