Skip to content

Registered aircraft · 21,464

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:95-26-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-26-13') 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:95-26-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-26-13')
  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:95-26-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-26-13')
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.

N107MRMeriden Aviation Center LLC · Meriden, CTBuilt 1977 · S/N 28-7816251 N107NDN107nd LLC · Wilmington, DEBuilt 1989 · S/N 2841214 N107TANelson Sarah J · Anchorage, AKBuilt 1975 · S/N 32-7540099 N10805Hill Ag-Air LLC · Pocatello, IDS/N 28-22677 N1080HAll2fly LLC · Atlanta, GAS/N 28-7715306 N1080UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2025 · S/N 28020231 N1080XFlying With Fitch LLC · Porter, TXS/N 28-7525278 N1082XWhitmer Ronald N · Ellsworth, KSBuilt 1975 · S/N 28-7505207 N1089XCoastal Aviation Partners LLC · Hubert, NCS/N 28R-7535236 N108AVDavis Robert S · Keystone Heights, FLBuilt 1974 · S/N 28-7415573 N108HWYale Companies LLC DBA · Fishers, INBuilt 2026 · S/N 2881997 N108NDMavity Michael D · Phoenix, AZBuilt 1990 · S/N 2841328 N108NSLyon Andrew L · Fairbanks, AKBuilt 1976 · S/N 32R-7680288 N108WMMoran William J · Media, PABuilt 1978 · S/N 32-7840187 N1092TH4s Aviation LLC · Longview, TXS/N 28-25565 N1092XNice Curtis A · Fort Myers, FLBuilt 1975 · S/N 28R-7535230 N1093XRoseville Aviation LLC · Roxboro, NCBuilt 1975 · S/N 28-7515386 N1094TGlover Anthony R · Louisville, KYBuilt 1969 · S/N 28R-31116 N10958Aero Quest LLC · Olive Branch, MSBuilt 2025 · S/N 28020251 N1095XVillegas Miguel Angel Cuello · Weston, FLBuilt 1975 · S/N 28R-7535239 N1096TEvans Charles B · Benbrook, TXS/N 28-26284 N1097THorizon Aviation LLC · Brooks, GABuilt 1969 · S/N 28-26287 N1099JLee'S Sea Air Inc · Kiana, AKBuilt 1967 · S/N 32-40274 N109ATAguillard Robert N · Memphis, TNBuilt 1974 · S/N 32-7540042 N109GPCash Management Consulting LLC · Granite Springs, NYBuilt 1977 · S/N 28-7816287 N109LDEast Bay Flight LLC · Alameda, CABuilt 1979 · S/N 28-7990292 N109MBFirefly Aviation LLC · Midland, TXBuilt 1978 · S/N 32R-7887238 N109RBClark William R · Anchorage, AKBuilt 1965 · S/N 282612 N10ASCrewson Gary · East Aurora, NYBuilt 1972 · S/N 28R-7235196 N10GHPeters Darvin Leroy · Meservey, IAS/N 28-20482 N10JKZalan Aviation LLC · Cincinnati, OHBuilt 1978 · S/N 32R-7887242 N10PJMiller Kenneth R · Russellville, KYBuilt 1967 · S/N 32-40285 N10ZVThat 70s Plane Inc · Athens, GABuilt 1977 · S/N 32R-7780390 N1102NWorld Class Athletic Surfaces Inc · Leland, MSBuilt 1968 · S/N 32-40756 N1102XMarak Enterprises LLC · Galena, MOBuilt 1975 · S/N 28-7505210 N1103XHolmgren Joel A · Chisago City, MNBuilt 1975 · S/N 28-7515388 N1104HSkydance Aviation LLC · Chesapeake, VAS/N 28-7725132 N1107HShurtz William W Jr · Medford, ORBuilt 1977 · S/N 28-7715308 N1108HAdk Flying Club Inc · Ballston Spa, NYBuilt 1976 · S/N 28-7715309 N1108XThompson Trisha L · Clearwater, KSBuilt 1975 · S/N 28-7515389 N1109XBruno Michael J · Pittsburg, CABuilt 1975 · S/N 28-7505211 N110JA3mw Farms Inc · Hallock, MNBuilt 1974 · S/N 28-7515135 N110LMGo Vertical Aviation LLC · Russellville, ALBuilt 1979 · S/N 28-7990277 N110MSMcaleer Scott · Scranton, IABuilt 1969 · S/N 28R-35194 N110TNMaloney Casey · Placerville, CABuilt 1972 · S/N 28-7305054 N110VPFly Aviation Corp · Wilmington, DEBuilt 1977 · S/N 28-7716189 N110WRRuffo-Silva LLC · Wilmington, DEBuilt 1978 · S/N 32R-7985056 N110WTW T Aviation LLC · Wichita, KSBuilt 1989 · S/N 3206050 N1111MRw Air LLC · Rock Hill, SCBuilt 1982 · S/N 32R-8329010 N1112XArrow Flyers LLC · Englewood, COS/N 28R-7535247

Back to AD 95-26-13