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.
N14VMKaindl Robert · Redmond, WAN14WFSamberg Scott S · Gillette, WYN14WGWest Coast Equipment Leasing LLC · Aurora, ORFirst renewal noticeN14WJSchifini Warren B · Dairy, ORN14YBKate Air LLC · Southlake, TXN14YHScofield Ryan · Greeley, CON14YPHubbard Scott Edward Jr · Deatsville, ALN14YUInternational Air Services Inc Trustee · Carson City, NVN14YVN14yv LLC · Oklahoma City, OKN15002Registered aircraftN15005Oliver Everett G · No Mankato, MNN15006Corio Salvatore J Jr · Warwick, RIN15007Marshall County Flying Club Inc · Lacon, ILN15018N15018 LLC · Sanger, TXN1501TRegistered aircraftN1501XBowser William K · Ball Ground, GAN15021Brandywine Flight School · West Chester, PAN15022Registration Pending · Riverside, CARegistration pendingN15024Whytes Inc · Coconut Creek, FLN15027Mallue Jeff · Springboro, OHN1502EElizbeth City State University · Elizabeth City, NCN1502RSale Reported · San Diego, CASale reported, pending cancellationN15035Wings Over Texas Holdings LLC · Denton, TXN15036Avocation Aviation Inc · Muncie, INN1503RBeck Wally J · Davenport, IAN15040Foote Samuel Henry Trustee · Paradise Valley, AZN1504RFlying Tiger LLC · Broomfield, CON1504XVerge Aeronautics LLC · Charlotte, NCN1505XFarrell Donald A · Owasso, OKN15064Kropp Christian Owner Trustee · Azle, TXN1506JHumbles Frank Forrest · Charleston, SCN1507TAero Care Inc · Orange, MAN1507XGolf November Aero LLC · Sunnyvale, CAN15089Tusla Technology Center School District #18 · Tulsa, OKN1508RAmspoker David A · Kingman, AZN1509FDragonfly Helicopter Service Ltd · North Dighton, MAN150AZPython Financial LLC · Kalispell, MTN150BRegistered aircraftN150BJDakota Air LLC · Delray Beach, FLN150CPNelson Chris L · Yankton, SDN150FCHart John Jr · Vallejo, CAN150GHOtto Gregory A · Plano, TXN150LELeading Edge Flight Academy LLC · Bend, ORN150LMBrake Michael S Trustee · Granbury, TXN150PFParagon Flight Training Co · Fort Myers, FLN150PTAlchin Aviation LLC · Durand, MIN150SUOhio State University · Columbus, OHN150TESummit Air LLC · San Diego, CAN150TH150th Aero Flying Club · Morristown, NJN150XTRice John D · Maddock, ND
Back to AD 2006-10-21