AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N13CEWilley R Scott · Layton, UTN13CMBolin William E · Smithville, OHN13CVRice Jonathan C · Vancouver, WAN13DBBauer Dereck R · Springfield, ORFirst renewal noticeN13ENGunn-Golkin Anna E · Cherry Hill, NJN13ESCsl Holdings LLC · Drayton, NDN13EXPitts Capital Of Nevada Inc · Las Vegas, NVN13FDSkythrills! LLC · Fullerton, CAN13GEParatus Air Inc · Auburn, INN13GRPayton Shawn · Hot Springs, ARN13GYMarvin Dean · Senoia, GAN13HKSkycombers Flying Club Inc · Pacoima, CAN13HNAb Prop Plane II LLC · Metairie, LAN13HUSzalay Dennis R · Mooresville, INN13HYKahler Enterprises LLC · Reedsburg, WIN13JBAltitude Aviation Services LLC · Mountain Home, IDN13JHL J H Consulting LLC · Greenleaf, IDN13JPFour Kicks Aviation LLC · Atlantic, IAN13KAAshby Clark S · Pleasant Grove, UTN13KFRockwood Blake T · Fort Worth, TXN13KRKaplan Ronald · Palm Beach Gardens, FLN13KTButler Bryan C · Brenham, TXN13LDOjala Denita L Trustee · Eden Prairie, MNN13LFLuciano Michael · Peachtree City, GAN13LPVanderhoof Jon A · Omaha, NEN13LS13 Lima Sierra LLC · Whitesboro, TXN13LWRegistered aircraftN13MDMoorstein Mark A · Manassas, VAN13MJVanderbilt Carl D · Saint Johns, FLN13NDDavis Robert N · Tipton, INN13NEQualitair LLC Trustee · MichelstadtN13NMC3 Aircraft LLC · Burnet, TXN13NVShepherd Howard M · Auke Bay, AKN13PBZimmerman Michael P · Verona, WIN13PMFly High Aviation LLC · Melrose Park, ILN13PRTomlinson Dana R · San Angelo, TXN13PZCroft Jordan · Rosamond, CAN13QMHerrick Eugene · Chicago, ILN13RGIsland Piper Llp · St Helena Is, SCN13RZBjornstad Eugene N Trustee · Girdwood, AKN13SPNew York State Police · Latham, NYN13TEMaddox Eric L · Grover Beach, CAN13TMSuntech LLC · St George, UTN13TTKlcc Holdings LLC · Boca Raton, FLN13UBJohnson Andrew P · Poquoson, VAN13VCWhite Paul J · Apex, NCN13WStl LLC · Savoy, ILN13WRBillys Blessing LLC · Louisburg, NCN13XMMathis Mark D · Richmond, TXN13YCBuckin 307 Taildraggers LLC · Casper, WY
Back to AD 2006-10-21