AD 80-25-07 R1
Registered aircraft · 25,370
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.
N5067XMiller Johnny D · Rhome, TXN5068DGeorge Delmond L · Dewitt, ARN5068GScaled Composites LLC · Mojave, CAN5068KMcclung Matthew T · Avon, INN5068LPark Jalynn C · Blacksville, WVN5068TAbc Leasing Inc · Oakdale, LAN5068UCaywood Beauregard Janice E · Hollis, NHN5068XNobles Ronny · Live Oak, FLN5068YFarnham Aviation Services LLC · Ames, IAN5069FMunns Dana K · Diamondhead, MSN5069GLeverich J E · Pampa, TXN5069HNehring Curtis A · Goleta, CAN5069TNiesciur Stephen V · Lancaster, NYN5069UGoff Bayou LLC · Shelby, MSN5069XWright Bruce M · Rosharon, TXN506DEAero Fliers LLC · Kalispell, MTN506GLKutschera Theodore C III · Callicoon, NYN5070GSky Fusion II LLC · Atlanta, GAN5070NWilkinson Dane W · Morgan, UTN5070UO'Donnell Paul E · Schuylerville, NYN5070XN566rm LLC · Wilsonville, ORN5071GRowland Dusters LLC · Raymondville, TXN5071HFosse David K · Carbondale, ILN5071KSkyview LLC · De Smet, SDN5072HRiebeling Eric Herbert · Reno, NVN5073HElite Planes LLC · Menifee, CAN5073NPavco Inc · Gig Harbor, WAN5074XBaker Jim · Hermosa, SDN5075XOpjorden Chris T · Litchfield, MNN50762Skyhawk Group · Kent, WAN5076NJb Aviation Flight School Inc · Wonder Lake, ILN5076RStable Approach Aviation LLC · Vestavia, ALN5076XPalmer Bryce P · Chugiak, AKN50770Schlegel Mark W · Waterford, MIN50771Flying Mermaid LLC · Aiea, HIN50772Donnelly Jennifer A · Hackettstown, NJN5077XLussier John A · Greene, RIN5078RBlue Goose Aviation Inc · Polson, MTN507GLSky West Aviation Inc Trustee · Albuquerque, NMN507HHGrossetete Nugget S · Edgewood, NMN5080FBraun Kevin J · Aberdeen, SDN5080XOber John A · Candor, NYN5081UKiloecho Aeronautics LLC · Tucson, AZN50822Nyhus Sharon L · Harvey, NDN50826Bristol Bay Capital LLC · Watkins, CON5082GJala Tech Services LLC · Social Circle, GAN5082RWings Over Texas Holdings LLC · Denton, TXN50838Ansee LLC · Seattle, WAN5083CTsf Inc · Bristol, WIN5083KLoewen Wielhelm N · Presidio, TX
Back to AD 80-25-07 R1