AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N511DMCapron Robert S · Seneca, SCN511DWD.B. Wood LLC · Levering, MIN511EMHomeless Dan LLC · Woodbine, GAN511EREmbry-Riddle Aeronautical University Inc · Prescott, AZN511FClarke Kenneth J · Anchorage, AKN511FTLatorre Bruce · Ferndale, CAN511GKAir Devices Company LLC · Alpena, MIN511GLFrerichs Brent A · Sandpoint, IDN511JBPlp Aircraft Classics LLC · Wilmington, DEN511JHRiester Bernard J Jr · Auburn, NYN511JKParcel Stephen · Franklin, NCN511LCLimocopter LLC · Orlando, FLN511LMSouthern Aircraft Consultancy Inc Trustee · Casper, WYN511MARrs Company Inc · Midville, GAN511MBPosner Leo S · Ambler, PAN511MFEastern Stearman Inc Trustee · Leesburg, VAN511MGCrock Dominic D · New Concord, OHN511MPN511mp LLC · Wilmington, DEN511NDSunrise Aviation Inc · Ormond Beach, FLN511PReigle Aviation South LLC · Orlando, FLN511PCClear Skies Avionics Inc · Clearwater, FLN511PMD & J Air Adventures Inc · Koloa, HIFirst renewal noticeN511PTCappe Investment Group LLC · Homestead, FLN511RFOlson Dean W · Shelbyville, KYN511RLHatch Leasing Co LLC · Marble Canyon, AZN511RVLarson Lawrence H · Estes Park, CON511SGHeinze Gregory L · Little Rock, ARN511SPFassas Alexander D · Richmond, KYN511TD23nv LLC · Grinnell, IAN511VMRadler Glenn · Livingston, NJN511WValdez Ricardo · Midlothian, TXN5120GGoering Vincent R · Hephzibah, GAN5120LClifford Scott P · Wallkill, NYN5120RKrause Aviation LLC · Geneva, ILN5120SIntentus Aviation LLC · Sunset, TXN5120VTreaster Implement Co Inc · Beloit, KSN5120WSeasons Of Life Publications LLC · Greenville, SCN5120XZimmerman Tom V · North Pole, AKN51213Shelley Aaron J · Corbin, KYN5121GWingsleasing LLC · Wichita, KSN5121HGilsdorf Jason M · Henning, MNN5121KTebbe Francis L · Maryville, ILN5121QClift William R II · Princeton, KYN5121SSandmann Ross · Plano, TXN5121WCarroll Thomas F · Independence, MON51221Provost Kevin H · North Swanzey, NHN51222Mbk Leasing And Consulting LLC · Lakeland, FLN5122EMertesdorf John P · Nicollet, MNN5122LJuliet Sierra Foxtrot LLC · Denver City, TXN5122QPyxis LLC · Cheyenne, WY
Back to AD 2007-04-19 R1