Skip to content

Registered aircraft · 657

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-25-08-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-25-08-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-25-08-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-25-08-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-25-08-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-25-08-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.

N720FSVero Executive Flyers Inc · Fort Pierce, FLS/N 421C1250 N721HBBrazilco Aviation LLC · Missouri City, TXS/N 421C0629 N723ESEs Owens LLC · Mustang, OKBuilt 1982 · S/N 421C1217 N726RTCrotts Aircraft Service Inc · Dodge City, KSBuilt 1976 · S/N 421C0087 N727ESHoover421 LLC · Rockport, TXBuilt 1977 · S/N 421C0268 N73DWQueen Bee Air Specialties Inc · Rigby, IDBuilt 1981 · S/N 425-0089 N73HMTrn Aviation LLC · Lewes, DES/N 421C0234 N744CAMay Richard Ullmann · Soquel, CAS/N 421C1014 N745CARegistration Pending · Dover, DERegistration pendingS/N 421C1043 N747CAAction Air Express Inc · Santa Monica, CAS/N 421C0850 N748CADesert Air Ambulance Inc · Menifee, CABuilt 1980 · S/N 421C0905 N749CABig Bear Resorts Inc · Big Bear Lake, CAS/N 421C1239 N74RFAir Flair Inc · Maurice, IABuilt 1983 · S/N 425-0153 N755BCMav Management LLC · Rockledge, FLBuilt 1978 · S/N 421C0497 N757RHPanther Partnership Equipment I LLC · Gibsonton, FLS/N 421C1049 N762CACullum Transportation LLC · North Charleston, SCBuilt 1981 · S/N 421C1214 N762TBAero Crafter LLC · Miami, FLBuilt 1977 · S/N 421C0213 N763JCPilot Services Of Ohio LLC · Loveland, OHBuilt 1976 · S/N 421C0211 N767ZRubin Broadcasting Inc · Dallas, ORS/N 421C0401 N76MJJzw Aviation LLC · North Salt Lake, UTBuilt 1981 · S/N 421C1204 N76SJRocket Air LLC · Carson City, NVBuilt 1984 · S/N 4250204 N783MBK-Aero LLC · Farmington, MNBuilt 1982 · S/N 425-0103 N784PFMiller Cory L · Winnsboro, TXS/N 425-0018 N784TTDodson International Parts Inc · Rantoul, KSBuilt 1981 · S/N 425-0145 N789RPBrindle Concepts LLC · Hanover, PABuilt 1975 · S/N 421C0009 N79JFFour Twenty One LLC · Kalispell, MTBuilt 1977 · S/N 421C0340 N808BVFlying Dutchman LLC · Waipahu, HIBuilt 1975 · S/N 421C0004 N80LGTru North Aviation LLC · Ironwood, MIBuilt 1975 · S/N 421C0021 N80PMSouthbreeze Aviation LLC · Wellington, FLBuilt 1983 · S/N 425-0181 N811NATm Aero LLC · Riverview, FLS/N 421C-1082 N811PGH&S Aircraft LLC · Lewes, DEBuilt 1984 · S/N 421C1413 N815SBN815sb LLC · Liberal, KSBuilt 1981 · S/N 425-0112 N817LLJg Aero LLC · Clermont, FLS/N 421C0230 N8181GAirplane LLC · Coeur D Alene, IDS/N 421C0302 N818AKWhirley Robert G · Santa Rosa, CABuilt 1981 · S/N 421C1085 N818DHCouch Fred · Fort Worth, TXS/N 421C0840 N818PLWings Aloft Inc · Eastvale, CABuilt 1981 · S/N 425-0109 N818TKInternational Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N 421C0873 N818XJays Aircraft Maintenance Inc · Costa Mesa, CAS/N 421C1021 N819RARonald Jinsky LLC · Beloit, WIBuilt 1978 · S/N 421C0522 N81LPSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1981 · S/N 421C-1083 N81RDPapaco LLC · Green Cove Springs, FLS/N 421C0291 N821KAKa Consulting LLC · San Juan, PRBuilt 1981 · S/N 421C1203 N821TTHome By Dark LLC · Fredericksburg, TXBuilt 1976 · S/N 421C0041 N822BKPropilot LLC · San Juan, PRS/N 421C0822 N826CMKuriel Michael · Las Vegas, NVS/N 421C0508 N834RMInfinity Properties LLC · Summerset, SDS/N 421C-0834 N8355Premier Plus Aviation Inc · Fort Pierce, FLBuilt 1979 · S/N 421C0668 N8378GPrecision Guidance LLC · Bloomington, ILBuilt 1977 · S/N 421C0310 N83CHLac Aero LLC · Liberal, KSBuilt 1981 · S/N 425-0025

Back to AD 91-25-08 R1