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.
N7408VM Twenty Inc · Bismarck, NDN7409GAero Quest LLC D/B/A · Olive Branch, MSN7411VDk Aero LLC · Wilmington, DEN7415KClarke Kenneth J · Anchorage, AKN7415VHall Kevin · Morgan, UTN7416GDreggors David Richard · Altamonte Springs, FLN74177Campbell Peter Shane · Knoxville, TNN7417VCottage Village Living II LLC · Brownfield, TXN7418VGilinger Lisa C · Santa Barbara, CAN7419GFlycarolina LLC · Concord, NCN741DPPleasant Aviation LLC · Mount Pleasant, TXN741GSReform Friendly Flyers LLC · Buhl, ALN7420GKellum Richard A · Seattle, WAN7421GLibby Matthew P · Castle Hill, MEN7421VYacuzzi Gerald A · Quinque, VAN7422GLafayette Escadrille Flying Club · Rock Spring, GAN7422VPanto Anthony · Jackson, NJN7424VMorgan James P · Arlington Heights, ILN7425GSmoke Eagles Inc · Downey, CAN7426GProvoncha Tina · Oak Harbor, WAN7426SDanick Mechanical Inc · Nicolaus, CAN7427GWilliams Jason R · Cordova, TNN7427VCrowe Aaron C · Hickory, NCN7429GDiditair Inc · Knoxville, TNN7429VMordica John E Jr · Hawk Point, MON7430VViaspot Inc · Sheridan, WYN7431VErnst Albert S III · Buda, TXN7432GNichols Roy D · Cadillac, MIN7432VSpires William B · Minden, NVN7433GStyles Brian P · Cullman, ALN7435VFreebird Ventures Inc · Oak Lawn, ILN7436GChickadee Aviation LLC · Rangeley, MEN7437VCoastal Airworx LLC · Middletown, NJN7438VGuillermo Geary B · San Diego, CAN7439GScheck Doug J · Medina, OHN743ACOlsson Charles E · West Point, VAN743JBLiley Brian A · Fall Branch, TNN743JFPanasuk Austin R · Sidney, MTN7441GSussex Aero Maintenance Inc · Georgetown, DEN7445VNisly Josh · Jackson Heights, NYN7447VBaca Robert A Trustee · Auburn, CAN7449GAvmajic LLC · Waterford, MIN7449VStarns Rod J · Belleville, ILN744ABBeverung Robert D · Manitowish Waters, WIN744HRStefan William C · Lockwood, MON744JAWiebe Albert · Seminole, TXN744MDeforest Shawn L · Lexington, NCN744SGGimblin Robert Steven Trustee · Yuba City, CAN7450GLewis Benjamin · Delano, MNN7450VNance Robert J · Bountiful, UT
Back to AD 80-25-07 R1