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.

N496JDDonnelly Jamy Christopher · Crystal River, FLS/N 27-2028 N4971PDodt Clinton Carl · Broomfield, COBuilt 1963 · S/N 27-573 N4973PAviation Business Corp · Saint Louis, MOS/N 27-574 N497JMBazzi Aviation LLC · Newark, DEBuilt 1972 · S/N 310Q0497 N497WWWin Win Aviation Inc · Wake Forest, NCBuilt 1978 · S/N 31T-7820045 N4980PLewis Clinton A · Antlers, OKBuilt 1963 · S/N 27-584 N4981PTri State Aero Inc · Martinsburg, WVBuilt 1963 · S/N 27-585 N4984PMoore Bruce W · Aledo, TXBuilt 1964 · S/N 27-588 N4986PLms Aviation LLC · Omaha, NEBuilt 1964 · S/N 27-590 N4987PRegion Flyers LLC · Valparaiso, INBuilt 1964 · S/N 27-591 N498CPConstruction Design Management LLC · Bowling Green, KYS/N TH-703 N49917Moore Steven D · Los Gatos, CAS/N 337-0784 N4991MOakview Homes LLC · Sullivan, MOBuilt 1978 · S/N TJ-146 N4992FGregory Aviation LLC · San Jose, CABuilt 1976 · S/N 34-7770005 N4999MStolutions LLC · Lexington Park, MDBuilt 1978 · S/N TC-2143 N499ATN633at LLC · Punta Gorda, FLS/N 414A0306 N499CRAce Tomato Company LLC · Daytona Beach, FLBuilt 1972 · S/N 27-4858 N499TCLieberman Richard M · Hellertown, PABuilt 1978 · S/N TC-2136 N499UVUtah Valley University · Orem, UTBuilt 2019 · S/N 4496454 N499XMParis Air Inc · Vero Beach, FLS/N 347250259 N49ARMoore Thomas A · Kennewick, WAS/N 421B0563 N49ATAirgo Inc · Centralia, ILBuilt 1981 · S/N 44-8107041 N49BMHarriman Aviation LLC · Pearland, TXBuilt 1977 · S/N 27-7754077 N49CBMacair Aviation LLC · Xenia, OHBuilt 1973 · S/N 33701551 N49DCenturian 94n LLC · Ripon, CABuilt 1974 · S/N TH-542 N49PMFlying Ace 75 LLC · Wilmington, DEBuilt 1970 · S/N TC-1376 N49RDDziak Chester · Jackson, MIBuilt 1966 · S/N 27-3192 N49WSJohnson Matthew N · Redgranite, WIBuilt 1966 · S/N 30-1393 N4ACWright Thomas L · Clyde, OHBuilt 1972 · S/N 33701464 N4ADValiair Lc Trustee · Casper, WYBuilt 1973 · S/N 421B0467 N4AFN4af LLC · Conroe, TXBuilt 1968 · S/N 421-0142 N4AS310 Air Ltd · Seville, OHBuilt 1964 · S/N 310I0094 N4BWPike County Aviation Inc · Waverly, OHBuilt 1972 · S/N TC-1446 N4CKLorenzo Walker Institute Of Technology · Naples, FLBuilt 1967 · S/N 30-1645 N4DRTotah John E · Kailua Kona, HIBuilt 1966 · S/N 27-3175 N4GSmith Jeary K · Greenfield, INBuilt 1967 · S/N 337-0686 N4HAArrington Harold M · Detroit, MIBuilt 1984 · S/N T30300283 N4HESouth Florida Aerobatics LLC · West Palm Beach, FLBuilt 1976 · S/N TH-787 N4JADiamond Aviation LLC · Tuscaloosa, ALBuilt 1994 · S/N TH-1714 N4KZAshleah Dna LLC · Amarillo, TXBuilt 1958 · S/N 23-1517 N4LWWilliams Jason Allen · Cypress, TXBuilt 1992 · S/N TH-1652 N4MCCoberly Adrian R · Manhattan, KSBuilt 1984 · S/N TJ-461 N4MUBlusky Properties & Investments LLC · Cameron, MOBuilt 1970 · S/N 421B0054 N4MZBank Of Utah Trustee · Salt Lake City, UTS/N 421C0829 N4NGWestern Skymasters LLC · Salt Lake City, UTS/N 33701787 N4PJAnderson Richmond E Jr · Orlando, FLBuilt 1972 · S/N 310Q-0515 N4PKJohnson David W · Mulvane, KSBuilt 1969 · S/N TC-1216 N4UFOtoole Joshua G · Letts, IABuilt 1976 · S/N TC-1978 N4VHFoster Chad H Jr · Uvalde, TXBuilt 1977 · S/N 421C0435 N4VSAircraft Montana LLC · Helena, MTBuilt 1974 · S/N 27-7405426

Back to AD 2004-25-16 R1