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.
N417FLPorter Richard · Round Hill, VAN417FPUtah State University · Logan, UTN417GGPro Water Solutions LLC · Henderson, TXN417GPFurkin Custom Marine LLC DBA · Tompkinsville, KYN417HPKempt Neil H · Canyon Country, CAN417JRBinary Ninjutsu LLC · Myrtle Beach, SCN417KKinsley Joshua P Trustee · Carlsbad, CAN417LLutes David W · Berryton, KSN417LFRussell Tommy Edward · Kingsport, TNN417LSUniversity Of Maryland Eastern Shore · Princess Anne, MDN417MCCollins Mark D · Signal Mountain, TNN417PSaltwater Aviation Inc · Tampa, FLN417PABird Acquisition LLC · Phoenix, AZN417PKFrancis David W · North Conway, NHN417PRCullen Donald N · New Brockton, ALN417RGWagner Aviation LLC · Laura, OHN417RTPender Bryan C · Rochester Hills, MIN417RVMiller Ira L · Yellville, ARN417SFLeonard Bruce D · Spokane, WAN417SPTonys Aerial Service Inc · Great Bend, KSN417TABrickler Alexander J · Tallahassee, FLN417WCMpi Warehouse Specialty Company Inc · Casper, WYN417XMiller Christopher A · Broomfield, CON417ZAlpha Tango Aircraft LLC · Wilmington, DEN418Vpropnw Inc · Walla Walla, WAN41801Freeman James E · Dalworthington Gar, TXN41802Trs Holdings LLC · Kalispell, MTN41803Minot Aero Center · Minot, NDN41804Beulen Brian V · Mesa, AZFirst renewal noticeN41805Fosdick Kenneth E · Plymouth, MAN41807Reid Robert W DBA · Independence, ORN41808Noble Raymond D · East Windsor, CTN41809Britten Ben K · North Pole, AKN4180JThomason Todd · Harrison, ARN4180SPalomino Princess Express LLC · Helena, MTN4180WHodson Bruce E · Madbury, NHN4180XJed Homes Inc · Lisbon, CTN4180ZSale Reported · Abilene, TXSale reportedN41811Farm Air Inc · Astoria, ILN41813Secrest Kenneth W · Griffin, GAN41816Privitt Bret J · Fort Worth, TXN41818Clinard Joshua G · San Luis Obispo, CAN41819Crop Jet Aviation LLC · Gooding, IDN4181DN4181d Corp Trustee · Wilmington, DEN4181MHayden Christopher J · Old Orchard Beach, MEN4181QMontgomery Steven D · Cleveland, OKN4181SArizona Type Ratings LLC · Sedona, AZN4181TKeystone Aerial Surveys Inc · Philadelphia, PAN4181XFly For Fun Aircraft LLC · Rockville, MDN4181ZBraswell William J · Belzoni, MS
Back to AD 2007-04-19 R1