AD 80-25-07 R1
Registered aircraft · 25,369
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
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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.
N6469BHale Debra A · Chugiak, AKN6469MGeneral Aviation Support Corp · Rosamond, CAN6469NKestrel Aviation LLC · La Center, WAN6469PSunrise Aviation Inc · Ormond Beach, FLN6469QBurl Jeffrey B · Hancock, MIN6469USoares Marcus K · Boca Raton, FLN646CDRegistered aircraftN6470YSkyhigh Enterprises LLC · Holland, MIN6471MLane Community College · Eugene, ORN6471QNugent Todd · Lake Bluff, ILN64728Systir Aviation LLC · Pittsburgh, PAN6472QCornay Louis J Jr · Franklin, TNN64736American Patrols Inc · Midland, TXN64739Registered aircraftN6473DTurner Glenn · West Melbourne, FLN6473UCardinal Exploration LLC · Northville, MIN6474QSale Reported · Sarasota, FLSale reported, canceledN64754Aerofeather Aviation Inc · Suffolk, VAN6475DDarcy Aviation LLC · Danbury, CTN6475QFlying Particles Inc · Livermore, CAN6475UVermilyea Ian · Pensacola, FLN6476GChupito Sabrocito LLC · Paso Robles, CAN6476QPacheco Enrique Roman · Albuquerque, NMN6476TAngel Air Ltd · Smithvile, OHN6476UFoster William B Jr · Chickasha, OKN6476WWill Investments Inc · Englewood, CON64776Christiansen Aviation LLC · Wilmington, DEN6477AAllen Chad R · Olathe, KSN6477TPhillips Christopher R · Peoria, AZN6478DBrezovich Ivan A · Birmingham, ALN6478PHellix LLC · Charlotte, NCN6478QGlasgow Christopher S · Morgans Point, TXN64791Tfa Aircraft Holding Corp · Daytona Beach, FLN64792Air Sal Leasing Inc · Fort Myers, FLN6479NSouth Aero LLC · Albuquerque, NMN6479QRegistration Pending · Myrtle Beach, SCRegistration pendingN6479UCm Aviation · Del Rio, TXFirst renewal noticeN6479YGv Air Inc · Medford, ORN647MTArbo Elijah B · Mount Chase, MEN647SBHyde Matthew L · Santa Cruz, CAN6480DFlyright Aviation LLC · North Las Vegas, NVN6480QTadlock Stephen S · Midland, TXN64814Propel Air LLC · Pottstown, PAN64815Channel Islands Aviation Inc · Camarillo, CAN6481JCape Flight Instruction Inc · Cotuit, MAN64823Training Planes LLC · Tampa, FLN6482MSilver Express Co DBA · Miami, FLN6482QStevenson Randall J · Wildwood, MON6482YSky West Aviation Inc Trustee · Albuquerque, NMN64831Obregon Ernest · Oakley, CA
Back to AD 80-25-07 R1