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.

N59936Kelly Kent R · Montgomery, ALBuilt 1975 · S/N 31-7512019 N5996MMedcare Emergency Medical Services Inc · Mcallen, TXBuilt 1972 · S/N 421B0334 N5996VM&M General Contractors Inc · Big Spring, TXS/N 34-7770275 N59982Duck L'Ranch LLC DBA · Fort Lauderdale, FLBuilt 1975 · S/N 31-7552071 N59987Wings As Eagles Mission Air Serv Inc · Oshkosh, WIBuilt 1975 · S/N 31-7552081 N599AHAvtran LLC · Clayton, MOBuilt 1984 · S/N 31-8452019 N599VKDeland LLC · Kalispell, MTBuilt 1970 · S/N TC-1346 N59CWN59cw LLC · Sheridan, WYBuilt 1979 · S/N 44-7995317 N59DLChannel Islands Aviation Inc · Camarillo, CABuilt 1979 · S/N ME-143 N59DSDjm Holdings LLC · Sugar Land, TXBuilt 1981 · S/N 34-8133065 N59EEKern Raymond L · Bedford, INS/N 27-3390 N59EHSale Reported · Dawsonville, GASale reported, pending cancellationBuilt 1978 · S/N 31T7820014 N59FCLamb Farms Inc · Oakfield, NYBuilt 1979 · S/N 31-7952117 N59FGState Of California · Sacramento, CABuilt 2024 · S/N 20800705 N59GYChieftain N59gy LLC · Saint Augustine, FLBuilt 1977 · S/N 31-7852017 N59HMBaron International Ventures LLC · West Palm Beach, FLBuilt 1975 · S/N TH-635 N59HVBoling Kyle C · Oak Hill, FLBuilt 1966 · S/N TC-1007 N59JCPegasus Air Charter LLC · Hartford, CTBuilt 1979 · S/N 31-7952181 N59NMGf Air LLC · Las Vegas, NVBuilt 1975 · S/N 421B0870 N59NWScanair LLC · Dover, DEBuilt 2013 · S/N 20800546 N5ALSchapansky Justin · Mount Airy, GABuilt 1973 · S/N TH-356 N5AMTexas La Flyers LLC · West Monroe, LAFirst renewal noticeBuilt 1979 · S/N 414A0441 N5BPTippettsolutions LLC · Fort Mill, SCBuilt 1980 · S/N TJ-315 N5BYWolff Emanuel C Md · Tucson, AZBuilt 1963 · S/N 30-105 N5BZBad Bird LLC · Elon, NCBuilt 1975 · S/N TH-662 N5CGSamair LLC · Blackshear, GABuilt 1979 · S/N 340A0751 N5CHHartshorn William T · Tucson, AZBuilt 1968 · S/N 421-0113 N5CNLewis Gentry Holdings LLC · Orlando, FLBuilt 1978 · S/N 414A0073 N5DValiair Ltd Co Trustee · Casper, WYBuilt 1978 · S/N 31T-7820080 N5DRHaslett Bradley A · Collierville, TNBuilt 1974 · S/N TC-1653 N5EBN5eb LLC · Medina, OHBuilt 1967 · S/N 30-1474 N5ERMill Direct Textiles LLC · Rollinsford, NHBuilt 1982 · S/N T30300137 N5HEFinancial Solution Services · Leesburg, FLS/N 340A0485 N5HMEvans Hayward D · Saint Augustine, FLBuilt 1973 · S/N 27-7305041 N5JKLizard Two LLC · Wilmington, DEBuilt 1981 · S/N TJ-295 N5JTTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1972 · S/N 33701468 N5KGCrossley Michael · Corona Del Mar, CABuilt 1968 · S/N TC-1068 N5LHIsland Creek Partners LLC · Alpine, CABuilt 1973 · S/N 310Q0939 N5MAScola Daniel B · Port Orange, FLBuilt 1967 · S/N 30-1622 N5NMNelson Jeffrey S · Darby, MTBuilt 1978 · S/N 414A0042 N5NNRkgrier LLC · Beckley, WVS/N 421C0446 N5PJGod Family Ministries International Inc · Elmont, NYBuilt 1972 · S/N 421B-0258 N5RZBbz Consulting LLC · Cody, WYBuilt 1974 · S/N 33701554 N5SUFlorida Skymaster LLC · Cape Coral, FLBuilt 1969 · S/N 337-1134 N5UTK&L Salty Air LLC · Stephenville, TXBuilt 1976 · S/N 421C0101 N5UZRick Aviation Inc · Newport News, VABuilt 1980 · S/N 44-8107008 N5VDRiverview Enterprises Inc · Perrysburg, OHBuilt 1978 · S/N 34-7870262 N5WENeilson Grant R · Richmond Hill, GABuilt 1976 · S/N TC-1981 N5WKEz Air Inc · Wilmington, DES/N 30-1853 N5WWClark Nikita C · Ontario, ORBuilt 1965 · S/N 30-708

Back to AD 2004-25-16 R1