Skip to content

Registered aircraft · 1,406

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-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:95-26-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:95-26-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:95-26-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:95-26-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:95-26-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.

N201DVDevine Robert L · Condon, ORBuilt 1977 · S/N 24-0088 N201DXDe Young Miles J · Florence, COBuilt 1976 · S/N 240027 N201EMccormick Richard · Morgan Hill, CABuilt 1979 · S/N 24-0912 N201EBIsrael Raj · Saint Joseph, MIBuilt 1977 · S/N 24-0112 N201ECHaselden William C · Hastings, MIBuilt 1978 · S/N 24-0635 N201EDRhodes Emmer F · Newton, IABuilt 1977 · S/N 24-0097 N201EENational University Services Inc · Salem, VABuilt 1976 · S/N 24-0076 N201EFDace Ronald K · New Berlin, ILBuilt 1977 · S/N 24-0130 N201EGGomez Roman Jr · San Antonio, TXBuilt 1978 · S/N 24-0479 N201EHLindsay Construction LLC · Fernandina Beach, FLS/N 24-0144 N201EJVann Dudley C · Greenville, NCBuilt 1977 · S/N 24-0159 N201EMShore Dogs LLC · West Hartford, CTBuilt 1977 · S/N 24-0147 N201EPStinchcomb Jason B · Aledo, TXBuilt 1976 · S/N 24-0074 N201EQM20j Aerospace LLC · League City, TXBuilt 1977 · S/N 24-0162 N201ERProject Freight LLC · Brunswick, GABuilt 1977 · S/N 24-0141 N201ESLaflin Steven · Idaho Falls, IDBuilt 1976 · S/N 24-0067 N201ETThomas Daniel C · Shady Shores, TXBuilt 1976 · S/N 24-0037 N201EWSondgeroth John · East Marion, NYBuilt 1978 · S/N 24-0446 N201FTuley Robert T · Colleyville, TXBuilt 1978 · S/N 24-0687 N201FAFooks Air LLC · Seaford, DEBuilt 1976 · S/N 24-0017 N201FBSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1977 · S/N 24-0105 N201FCNeely Michael D · Huson, MTBuilt 1976 · S/N 24-0064 N201FGReed Philip B · Martinsville, INBuilt 1977 · S/N 24-0179 N201FJJensen Keith E · Pocatello, IDBuilt 1977 · S/N 24-0185 N201FLFairservice John G Jr · Mechanicsville, VABuilt 1977 · S/N 24-0154 N201FNRobello Michael T · Belton, TXBuilt 1977 · S/N 24-0238 N201FPShank Carl V · Beaver Falls, PABuilt 1977 · S/N 24-0189 N201FQWalker Lisa A · Capistrano Beach, CABuilt 1977 · S/N 24-0194 N201FTCurran Stephen S · Coppell, TXBuilt 1977 · S/N 24-0101 N201FVWest Lake Houston Aviation LLC · Houston, TXBuilt 1977 · S/N 24-0213 N201FXMr Dent Inc · Manheim, PABuilt 1977 · S/N 24-0206 N201FYJauregui Alberto T · Key Biscayne, FLBuilt 1977 · S/N 24-0210 N201GCBosse Don R · Bellville, TXBuilt 1977 · S/N 24-0169 N201GDEide Glenn Mitchell · Wayzata, MNBuilt 1977 · S/N 24-0216 N201GESanders Michael W · Austell, GABuilt 1977 · S/N 24-0103 N201GHPayne Jason C · Thomaston, CTBuilt 1976 · S/N 24-0075 N201GJAllmarc LLC · Molalla, ORBuilt 1977 · S/N 24-0134 N201GNThomas J Smith · Baton Rouge, LAS/N 24-0219 N201GPSale Reported · Sheridan, WYSale reportedBuilt 1976 · S/N 24-0054 N201GQHolm Chris C · Myrtle Point, ORBuilt 1977 · S/N 24-0221 N201GRBischoff Roy H III · Belleville, ILS/N 24-0222 N201GTHave Blue Aviation LLC · Philipsburg, MTBuilt 1978 · S/N 24-0575 N201GXRalph John M · Casper, WYBuilt 1977 · S/N 24-0225 N201GYBrill Daniel C · Stratford, CTBuilt 1977 · S/N 24-0226 N201GZNelson Jordy D · Marysville, KSBuilt 1977 · S/N 24-0229 N201HMettlen Mitchell J · Lucas, KSBuilt 1981 · S/N 24-1111 N201HAAlken Glass Unlimited LLC · Devils Lake, NDBuilt 1977 · S/N 24-0227 N201HBCollier Ernie · Winter Haven, FLBuilt 1977 · S/N 24-0209 N201HCFink Katherin · Scottsdale, AZBuilt 1976 · S/N 24-0052 N201HGWright D Anthony · Davisburg, MIBuilt 1977 · S/N 24-0232

Back to AD 95-26-16 R1