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.
N245MAJc Aviation LLC · Bedminster, NJN245MBRobinson Gary O · Escondido, CAN245MCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN245SSharpaire LLC · Wilmington, DEN245SCNorman Brent B Trustee · Rutledge, TNN245SFLindley Robert F III · Williamson, GAN245TCTexas State Technical College · Waco, TXN245TFAir Fleet Holdings LLC · Addison, TXN245TWLudewig Christopher J · Northfield, MNN24608Haney Jeffrey B · Carrollton, GAN2460AAmerican Aviation Inc · Brooksville, FLN2460QHamilton Aviation Group LLC · Lula, GAN2460RScilex Richard D · Hixson, TNN2460UAccelerated Aviation Instruction LLC · Owatonna, MNN2460VBenson Dustin R · Sheyenne, NDN24612Iasco Flight Training Inc · Redding, CAN24613Ameriflyers Of Texas Inc · Addison, TXN24615Mclean Aviation LLC · Phoenix, AZN24619Atp Aircraft 2 LLC · Wilmington, DEN2461EWadekamper Leo · Helena, MTN2461FDietz Thomas · Mill Valley, CAN2461MAbdulla Urooj · Damon, TXN2461PMaxxum Financial Group Inc · Destrehan, LAN2461QJessi Air Ltd · West Salem, OHN24625Mason Ron · Tallahassee, FLN24629Hurd Jeffrey R · Gilbert, AZN2462PSan Diego Aviation LLC · San Diego, CAN2462RTrade Winds Aviation Holdings LLC · Lewes, DEN24631San Jose Mixer Inc · Gilroy, CAN2463BMichigan Dept Of Natural Resources · Roscommon, MIN2463SNjnj Aviation LLC · Belmont, CAN24640Olive Aviation LLC · Anchorage, AKN2464CCantera La Rita Inc · San Juan, PRN2464DAero Equities LLC · Ventura, CAN2464HSo Cal Leasing LLC · El Cajon, CAN2464QWilson Jeff · White Bluff, TNN2464WOktela Steven L · Melbourne, FLN24652Graber Howard J · Montgomery, INN2465RDarrow Brett · Minerva, NYN2465UProtzair LLC · Aiken, SCN24662Dumay Chad · O Fallon, MON24663Stuber Paul A · Kansas City, MON24665Axiom Development & Consulting LLC · Atlanta, GAN2466TSvetfur Aviation LLC · Camden, SCN2466VD & L Aircraft Leasing LLC · Ormond Beach, FLN2466XSpengler Raymond F Jr · Longview, TXN24671Mustang Sally Aviation LLC · Signal Hill, CAN24672Gurgainous Larry K · Fredericksburg, VAN24673R66 And Cattle LLC · Southlake, TXN24676Goren Matthew B · Wilmette, IL
Back to AD 2006-10-21