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.
N6262QNess David R · Ocklawaha, FLN6263GPerfect Aircraft LLC · Ocala, FLN62640Condor Aviation LLC · Bethlehem, PAN6265ALewis Albert D · Newark, OHN6265DCommander Funk Llp · Portland, ORN62660Steele Timothy W · Hancock, NHN6266AGhaemi Mike · West Hills, CAN6266VSix Pack Aviation LLC · Pocono Pines, PAN6267HNorthern Wings Aviation LLC · Bozeman, MTN6267YZero Four Twelve LLC · Clovis, NMN62689Optic Air LLC · Sioux Center, IAN6268DSafety In Motion Flight Center Inc · Puyallup, WAN6268UBlair Management Holdings LLC · Carefree, AZN62690Aerosim Academy Inc · Sanford, FLN62694American Patrols Inc · Midland, TXN6269DCongressional Flying Club Inc · Gaithersburg, MDN6269TN6269t · Lampe, MON6269UKetola Keith C · Seaside, CAN626AFCape Fear Pilots LLC · Bald Head Island, NCN626APDobry Robert S · Crescent City, FLN626LDAerofleet LLC · Oldsmar, FLN626PABird Acquisition LLC · Phoenix, AZN6270RAbout Time Aviation · Springfield, ORN6270UFarrah Steve · Northlake, TXN6273TLandair Bovinae LLC · Canyon, TXN6273UButsky Gary C · Livonia, MIN62740Doomac LLC DBA · Peyton, CON6274AA V T210 LLC · Palmdale, CAN6274DOracle Aviation LLC · Omaha, NEN6274LTitterton Edward G III · Philadelphia, PAN6274TGlenum Donald L III · Norfolk, VAN6274UEaves Christopher C · Salt Lake City, UTN6274VDollbaum Robert A · Southfields, NYN6275RFoode Frank J · Cordova, AKN6275USityar Frank A · Aptos, CAN6276PHoecher Robert T · Anchorage, AKN6276TFinn Steven F · El Paso, TXN6276UKummer Nicholas T · Wenatchee, WAN6277DBockstiegel Bill C · Leadville, CON6278GAvila Sarah · Long Beach, CAN6278RCress LLC · Dover, DEN6278SFlick Damon · Dansville, NYN6278UHarney Michael E · Alta Loma, CAN6278YTown & Country Aviation LLC · Sunnyvale, CAN62796Kane Chuck · Thousand Oaks, CAN6279MBlanchard Michael J · Cleveland, ARN6279PIndiana State University · Terre Haute, INN6279VRegistered aircraftN627APRegistered aircraftN627BTAviation Global Inc · Saint Augustine, FL
Back to AD 80-25-07 R1