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.
N135KAcord Aviation Co L L C · Chandler, OKN135LUS Department Of The Interior · Boise, IDN135MAAppel Joshua · Wasilla, AKN135MTMiddle Tennessee State University · Murfreesboro, TNN135RCCox Steven C · St George, UTN135RJKontz Gary Lee · Canby, MNN135SSpencer William D · Martinsville, VAN135TSN135ts LLC · Lima, OHN135TWValiair Lc Trustee · Casper, WYN135UInter American University Of Puerto Rico · Bayamon, PRN135WPLager Patrick J · Hollis, NHN1360JLambert Brian · Tahlequah, OKN1360TDibrino Ruth G · Hillsboro, ORN1360WRiggs Aviation LLC · Heath, TXN13612Harry Philip Scott · Asheville, NCN1361CHuckaby William C Trustee · Loudon, TNN1361JWilliams Jack G · Wichita, KSN1361MLux Aero Operations LLC · Belmont, CAN1361SHughes Shannon E · Jameson, MON13621Fowler Gerald · Springfield, MON1362JHendrix Aviation Inc · Plantation, FLN13647Winn William D · Fallbrook, CAN1364WTriple B Properties Ltd · Aledo, TXN13656Groth Abigail · Oxford, GAN13667Fuller Air Inc · Wilmington, DEN1366RParodi Carlos Guillermo · Austin, TXN1367TN1367t LLC · Mount Dora, FLN1367WSelover Richard D · Colusa, CAN13681Davis Jerry L · Rural Retreat, VAN1368PDoan William Terry · Furlong, PAN1369Low Country Skyways LLC · Wilmington, DEN13690Dyre Daniel · Park Rapids, MNN1369JWalsh Mark · Andover, MAN1369QAmeriflyers Of Texas Inc · Addison, TXN1369TWings Over Texas Holdings LLC · Denton, TXN136ACPreacher John R · Jackson, GAN136AVHarford Archer Owners Group LLC · Bel Air, MDN136CCShelk John Brian · Bend, ORN136CPMaule Flight Inc · Moultrie, GAN136DBuckeye Ridge Farm LLC · Vidalia, GAN136DCStreamline Aviation LLC · Battlefield, MON136DWSun Aircraft Management LLC · Ormond Beach, FLN136FSale Reported · Broomfield, COSale reportedN136FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLN136HFHeritage Asset Leasing LLC · Ronkonkoma, NYN136HSHenderson State University · Arkadelphia, ARN136MMMiller Carl A · Vero Beach, FLN136SASouthern Aircraft Consultancy Inc Trustee · Casper, WYN136SMMartens Aerosports LLC · Garden City, NYN136TRRv6a136tr LLC · Merrillville, IN
Back to AD 2006-10-21