AD 80-25-02 R2
Registered aircraft · 6,348
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-02-R2')
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-02-R2')
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-02-R2') 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-02-R2') 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.
N2794Autry Timothy R · Stedman, NCN2794MRifenburg Brian K · Ward Cove, AKN279TAspenglow LLC · Talkeetna, AKN27CWRebr Holdings LLC · Hernando, FLN27HSSchooler Harold L · Chico, CAN27KDArnold Lon B · Huntington, UTN27RBBassett Ronald E · Monticello, INN27RDWengerd Lavern W · Heron, MTN27ZARegistered aircraftN28Registration Pending · Palos Park, ILRegistration pendingN2800DHamann Russell M · Clear Lake, SDN2802MSkyone Aero Services LLC · Castro Valley, CAN2806WOllmann Paul W · Poplar Grove, ILN2809MCarlos Sean N · Togiak, AKN280AMSabol John · Smithville, TXN2810MDavis Ronald L Jr · Soldotna, AKN2811GNablo Dustin · Haddam Neck, CTN28143Powell Kenneth W · Ann Arbor, MIN28144Maloy Toby · Albuquerque, NMN28151Stewart Thomas · Churchville, NYN2815TNorwest Ventures LLC · Sagle, IDN2818GRenda Joseph · Dunnellon, FLN2819MDzr Enterprises LLC · Missoula, MTN2820MFlynt Gary J · Baytown, TXN2821MPacker Louis M · Wasilla, AKN2823MFedorka Paul R Trustee · Soldotna, AKN2827MAdams James M · Pontiac, ILN2828GSparrow Hawk Aviation LLC · Moraine, OHN282CGCampbell Tanner · Augusta, KSN2830GSandoval Jennifer · Tucson, AZN2832GFields Michael L · Rockwood, TNN2836MSwihart Matthew S · Hood River, ORN2837Helgeson Echeverri Mary Ann B · Surprise, AZN283AMRegistration Pending · Gulfport, MSRegistration pendingN283THall Terry A · Pennsboro, WVN2845MBrasher Kerry W · Scotts Hill, TNN2850GSlip And Skid LLC · Sanger, TXN2850MHarvey Timothy A · Colusa, CAN2853MH&M Aviation · Hazelton, NDN285TCooper John H III · Wasilla, AKN2862MFrederick David · Juneau, AKN2868ZWanda Collins Professional Pilot Services LLC · Madisonville, TXN2869GRay Richard A · Morristown, NJN286THenry James G · Bonita, CAN2870MJohnson James F · Florence, MTN2875MSzumal Brent · Wasilla, AKN2876MJohnson William A · Dillingham, AKN2877HHeusdens Mark A · Kansasville, WIN287EBBoorom Mikel E · Jackson, MIN287TMiller Timothy P · Anchorage, AK
Back to AD 80-25-02 R2