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.

N310TPSouthern Arkansas University Tech · Camden, ARS/N 310J0046 N310VHVan Horn Jeffrey · Jonesboro, ARBuilt 1969 · S/N 310P0180 N310WDHernandez Jr Raymond Trustee · Burleson, TXBuilt 1969 · S/N 310Q0238 N310WGMunro Donald W · Commerce Township, MIBuilt 1972 · S/N 310Q0412 N310WPPardue William E · Fort Worth, TXBuilt 1965 · S/N 310J0019 N310WVHill Rick A · Bridgeport, WVBuilt 1973 · S/N 310Q0976 N3110ATalon Group LLC · Marietta, GABuilt 1979 · S/N TC-2207 N3110LYellowfin Aero LLC · Seminole, TXS/N 310J0110 N31110Anica Properties LLC · Chandler, AZBuilt 2005 · S/N 3449319 N3111KChristiansen Aviation LLC · Wilmington, DEBuilt 2007 · S/N 4496240 N3114LWaniczek Otto J · Lancaster, CABuilt 1965 · S/N 310J0114 N3117AAtp Aircraft 8 LLC · Wilmington, DEBuilt 2008 · S/N 4496259 N3117LAtp Aircraft 2 LLC · Wilmington, DEBuilt 2005 · S/N 4496202 N3118HAtlantic Aviation Group Inc · Miami, FLBuilt 1994 · S/N TH-1718 N3119PKovacs Thomas A · Nashua, NHBuilt 1957 · S/N 23-1041 N311ANValiair Ltd Co Trustee · Casper, WYBuilt 1970 · S/N P-141 N311BBCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1966 · S/N 27-3313 N311BC311bc LLC · Channelview, TXBuilt 1976 · S/N 421C0132 N311BTBob Air LLC · Concord, MAS/N 414A0453 N311CASouthern Wings LLC · Shreveport, LABuilt 1977 · S/N 421C0252 N311CHWings Of Eaglz LLC · Lamoni, IAS/N TK-149 N311EFLibra Air Inc · Las Vegas, NVBuilt 1979 · S/N 44-7995226 N311FTR&D Land And Air LLC · St Simons Is, GABuilt 1964 · S/N TC-744 N311GRPfeffer David D · Jacksonville, FLBuilt 1966 · S/N 310K0199 N311JEJps Aviation LLC · West Chicago, ILS/N 27-7754053 N311JHHuaco Aviation LLC · Waco, TXBuilt 1980 · S/N 421C0814 N311KMDream Flight Florida LLC · Wellington, FLBuilt 1979 · S/N 340A0757 N311NSimmons Calvin L · Peralta, NMBuilt 1970 · S/N P-130 N311SRed Rock Construction Inc · Hydro, OKBuilt 1964 · S/N 30-328 N3120WWiese Chuck F · Portland, ORBuilt 1973 · S/N TC-1645 N3121WAlpha Dog Aviation LLC · Marco Island, FLBuilt 1973 · S/N TH-410 N3122LE C G Aviation Inc · Orange, CABuilt 1965 · S/N 310J0122 N3122RMarrow Henry G · Southern Pines, NCBuilt 1994 · S/N TH-1722 N3124WBaron 24w LLC · Outing, MNBuilt 1973 · S/N TH-411 N3125GEastern Kentucky University · Richmond, KYS/N 4496214 N3125LOxley Lake Solutions LLC · Lawton, MIBuilt 1965 · S/N 310J0125 N3126PJmc Duryea Investments LLC · Ocala, FLBuilt 1957 · S/N 23-1049 N3127LContainer Stop Inc · Paso Robles, CABuilt 1965 · S/N 310J0127 N3127PThorn Blake A · Coupeville, WAS/N 23-1050 N3127TSouth Valley Internet Inc · San Martin, CAS/N 340A-0025 N3128TWingsleasing LLC · Wichita, KSS/N 4496219 N3129PJudie Bear Air LLC · Bend, ORBuilt 1957 · S/N 23-1052 N312AKSafeco Leasing LLC · Port Alsworth, AKBuilt 1973 · S/N 31-7305015 N312CDMcwhorter Properties Graysville LLC · Anniston, ALBuilt 1980 · S/N 31-8052182 N312CMChristiansen Aviation LLC · Wilmington, DEBuilt 1978 · S/N ME-103 N312CWLb Wings LLC · Midland, MIBuilt 1981 · S/N TH-1204 N312MXRapid Imaging Solutions LLC · American Fork, UTBuilt 1965 · S/N 310J0033 N31309Meadowlake Airpark LLC · Lenoir City, TNS/N TC-1524 N3130WWarbirds East Inc · Fairhope, ALBuilt 1973 · S/N TC-1635 N3132PSarratt Curtis H · Annapolis, MDBuilt 1957 · S/N 23-1056

Back to AD 2004-25-16 R1