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.

N35841Flyingvine LLC · Gilford, NHBuilt 1980 · S/N 31-8012054 N3586DDurrell Lee W · Memphis, TNBuilt 1980 · S/N 31-8012065 N3587PMsm587p LLC · Jericho, NYS/N 31-8052120 N35890Ja Aero LLC · Chicago, ILBuilt 1980 · S/N 31-8052139 N3589BAir Arctic Inc · Fairbanks, AKBuilt 1980 · S/N 31-8052134 N3589XMarc Inc · Bolton, MSBuilt 1980 · S/N 31-8052138 N358CFApm Leasing LLC · Casper, WYBuilt 1978 · S/N 44-7995115 N358CMEathcirc 08 LLC · Tucson, AZBuilt 1989 · S/N TH-1546 N358PBN358pb LLC · Amarillo, TXBuilt 1977 · S/N TJ-90 N358TCEclipse Air Works LLC · Harker Heights, TXS/N TC2398 N358YJuliet Air LLC · Cincinnati, OHS/N TH-1551 N3590AHill Lonnie R · Gainesville, GABuilt 1969 · S/N TC-1312 N3590BTranquil Air LLC · Lighthouse Point, FLBuilt 1980 · S/N 31-8052143 N3590DSale Reported · Xxx, OKSale reported, canceledBuilt 1980 · S/N 31-8052144 N359CMarc Inc · Bolton, MSS/N 31-7912109 N359DWDurrell Lee W · Channel IslandsS/N 30-770 N359LULewis University · Romeoville, ILBuilt 2025 · S/N 4496596 N359PTilloo Aviation LLC · Pensacola, FLS/N TH-1229 N359RXD-Kal Leasing LLC · Meadowbrook, WVS/N 31-8012030 N35ADSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1966 · S/N 30-1121 N35ARRaven Air LLC · Miami, FLFirst renewal noticeBuilt 1977 · S/N 347770254 N35FSSelistli LLC · San Mateo, CABuilt 1974 · S/N 421B0831 N35GKPacific Flight Aviation LLC · Costa Mesa, CAS/N 3449174 N35JCRogowski Paul · Dallas, GABuilt 1964 · S/N TC-828 N35RDIngersoll Grove LLC · Springfield, MABuilt 1977 · S/N 31-7852039 N35TGPerkins David A · Locust Grove, OKS/N 340A1203 N36049Koppenhaver Seth Tyson · Oro Valley, AZBuilt 1978 · S/N 34-7870287 N3605MIsland Bound LLC · Dunedin, FLBuilt 1978 · S/N 34-7870118 N360AKLindquist Scott DBA · Minnetonka, MNBuilt 1968 · S/N P-18 N360CFCoast Flight Training And Management Inc · San Diego, CAS/N 44-7995307 N360LULewis University · Romeoville, ILBuilt 2021 · S/N 4496522 N360UAdrenalyne Consulting LLC · Scottsdale, AZBuilt 1997 · S/N TH-1834 N36106Leaseair LLC · Wilmington, DEBuilt 1978 · S/N 34-7870293 N3611BRestorations & Rentals LLC · Tulsa, OKBuilt 1970 · S/N 27-4579 N361AHHodge Cleophas U · St Thomas, VIBuilt 1980 · S/N TJ-308 N361GCFff Leasing LLC · Dover, DES/N 414-0616 N3622TShaw Aviation LLC · Greenleaf, IDBuilt 1974 · S/N TH-479 N362BMAmerican Valet Air Inc · Wilmington, DEBuilt 1973 · S/N 27-7305171 N362BPLight & Variable LLC · Arlington, VABuilt 1979 · S/N 27-7954048 N362DLBee Line LLC · Millwood, GABuilt 1992 · S/N TH-1653 N362HPCaporale Ronald L · Dillon, MTS/N TC-2362 N36345Altair Aircraft LLC · Gainesville, FLBuilt 1978 · S/N 34-7870321 N36369Eastern Aeroworks LLC · Punxsutawney, PABuilt 1978 · S/N 34-7870323 N3636CSale Reported · Galena, KSSale reportedBuilt 1966 · S/N 310K0137 N36371Akridge Jeffry J · Moses Lake, WAS/N 34-7870324 N363NCN363nc Corp Trustee · Wilmington, DEBuilt 2007 · S/N 3449363 N36482Fair Air Inc · Bloomfield Hills, MIBuilt 1978 · S/N 34-7870335 N36487Steele Charles C · Hollandale, MSS/N 34-7870337 N364GLLeep Enterprises LLC · Mishawaka, INBuilt 1976 · S/N TC-1983 N36536Sky High Investments LLC · Greenwood, INBuilt 1978 · S/N 34-7870341

Back to AD 2004-25-16 R1