Skip to content

Registered aircraft · 5,086

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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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.

N88PZ88pz LLC · Clifton Park, NYS/N 27-7754112 N88RARusso Mark · Stevensville, MTBuilt 1996 · S/N 4636034 N88RHKeystone Flyer LLC · Avon, INBuilt 1975 · S/N 32R-7680065 N88TGMakushin Logistics LLC · Fairbanks, AKBuilt 1984 · S/N 31-8452020 N88TLAh Legacy LLC · Orlando, FLBuilt 1980 · S/N 31-8152066 N88VBBjelland Richard A · Galt, CABuilt 1967 · S/N 27-3609 N88ZMFlorida Aero Services Sales Division Inc · Brandon, FLBuilt 1976 · S/N 31-7752016 N8900PCabrejos-Guillen Roberto · Wichita, KSBuilt 1965 · S/N 24-4355 N8901PRead Robert S · Peoria, AZBuilt 1966 · S/N 24-4356 N8902PFarris Greg T · Ann Arbor, MIBuilt 1966 · S/N 24-4357 N8903PBeyer Marvin A Jr · Taft, TXBuilt 1966 · S/N 24-4358 N8905NHigh Noon Leasing LLC · Anchorage, AKS/N 32-40690 N8905PBulle Jason L · Phoenix, AZBuilt 1966 · S/N 24-4360 N8906PComanche Inc · Leoti, KSBuilt 1966 · S/N 24-4361 N8907NCrain Roan · Cookeville, TNS/N 32-40693 N8908NH & H Aviation LLC · Provo, UTBuilt 1969 · S/N 32-40695 N8909NKrull Doug · Hendersonville, TNS/N 32-40696 N890HMarc Inc · Bolton, MSBuilt 1980 · S/N 31-8052194 N8910KCoulter Ts LLC · Midway, UTBuilt 1977 · S/N 32-7840046 N8910NRam Aeronautics LLC · Wichita Falls, TXBuilt 1969 · S/N 32-40698 N8910PComanche LLC · Peachtree City, GABuilt 1966 · S/N 24-4365 N8911PVarga Craig S · Chino Valley, AZBuilt 1966 · S/N 24-4366 N8914NTreetop Flyers LLC · Vashon, WABuilt 1969 · S/N 32-40704 N8914WDines Stephen R · Monument, COBuilt 1964 · S/N 28-10483 N8915PLegacy Aviation Mid-Michigan LLC · Kalamazoo, MIBuilt 1966 · S/N 24-4370 N8916NBundy Richard · Little Egg Harbor, NJBuilt 1969 · S/N 32-40707 N8917PLogsdon James C · Hanford, CABuilt 1966 · S/N 24-4372 N8918NStratton Erin B · Baton Rouge, LABuilt 1969 · S/N 32-40711 N891AWColonial Aviation LLC · Morristown, NJBuilt 1989 · S/N 4622024 N891CBKal-1 LLC · Wichita, KSBuilt 1980 · S/N 31-8012064 N8921POwens Gregory E · Kendallville, INBuilt 1966 · S/N 24-4377 N8922NKew Malcolm M · Hercules, CABuilt 1969 · S/N 32-40717 N8923NMiller Jarred J · Burton, OHBuilt 1969 · S/N 32-40718 N8924NRobinson Andrew · Auburn, CABuilt 1969 · S/N 32-40720 N8925NMackay James R · Corunna, MIS/N 32-40721 N8925PGriffith James E · Gig Harbor, WABuilt 1966 · S/N 24-4381 N8927NHoffman Gary D · Spencer, NEFirst renewal noticeBuilt 1969 · S/N 32-40724 N8928PGeorg John B · La Crosse, KSBuilt 1966 · S/N 24-4384 N892MMWings Of Dubuque LLC · Dubuque, IABuilt 1980 · S/N 31-8112029 N892RCSmw-Cjh Corp · Wilmington, DEBuilt 1966 · S/N 24-4379 N892TGTeo Steel Inc · Ramer, TNBuilt 1980 · S/N 31-8012053 N892TWTeo Steel Inc · Ramer, TNBuilt 1978 · S/N 31-7812111 N8931PDuncan Michael J · Cordova, TNBuilt 1966 · S/N 24-4387 N8932P260b LLC · San Diego, CABuilt 1966 · S/N 24-4388 N8936PGesenhues Bernard J · Canton, OHBuilt 1966 · S/N 24-4392 N8937NSchewe William M · Greenville, ILFirst renewal noticeBuilt 1969 · S/N 32-40735 N8939NOakley William J · Kildeer, ILBuilt 1969 · S/N 32-40741 N893CBAec Navajo LLC · Wilmington, DES/N 31-8012007 N8940PDavie Andrew S · Stony Point, NYBuilt 1966 · S/N 24-4396 N8942NMinnema Samuel S · Fairbanks, AKS/N 32-40742

Back to AD 91-21-01 R1